Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “lutea” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
lutea5481907(None) 
lute46341011lute_
luteal64411481luteal
luted64826141luted
lutes55836661lutes
bute66739672bute_
buteo75419892buteo
butes714535872butes
cute66440452cute_
cuter74728222cuter
cutes79438312cutes
cutey105819792cutey
elute54822572elute_
eluted74915262eluted
elutes64020312elutes
flute86823752flute_
fluted104917162fluted
fluter95316862fluter
flutes95421782flutes
flutey125212522flutey
glute66020902glute_
gluteal854242gluteal
glutei7409742glutei
gluten74210752gluten
glutes74517672glutes
gutta64613382gutta
jute115327892jute_
jutes125125132jutes
late47560482late_
lated65240672lated
laten54328342laten
later54843922later
latex124717112latex
lea37660182l__ea
lite47054542lite_
liter54736342liter
lota47233502lot_a
louted74920692louted
lube64731562lube_
lubed85319892lubed
lubes74727992lubes
luce65132572luce_
luces75528432luces
lude55331642lude_
ludes65728852ludes
lues45943552lu_es
luffa11409022luffa
luge55531642luge_
luged74019092luged
luger65322082luger
luges65928752luges
luma65527522lu_ma
lumen75220902lumen
luna46229852lu_na
lune47140492lune_
lunes55337772lunes
lunet56835422lunet
lunted74517522lunted
lure45142462lure_
lured65427492lured
lurer54625312lurer
lures56138532lures
lurex124816732lurex
lusted74319442lusted
luster64023672luster
lustra6358892lustra
lutein6311262lutein
luteum837782luteum
lutz136826322lut_z
lutzes153711922lutzes
luxe115222692luxe_
luxes124921502luxes
lycea10418942lycea
lytta888062lytta
mute65136872mute_
muted85023382muted
muter74525542muter
mutes75033782mutes
outeat62824532outeat
outed65429062outed
outer55633302outer
plutei8408902plutei
sutra54217932sutra
sutta54015332sutta
tea37353322__tea
tutee5423522tutee
ultra539362ultra
urea46528052_urea
uta37425582_ut_a
ute35335882_ute_
utes45930882_utes
uvea74712652_uvea

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691538000.0931921408.6
2DLD Change Limit53800921.51635488.1
3Display Results92920.0137076.9
 (SQL Overall)178691921.622110167.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.