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 “jeux” with Change Limit: [1] [2] [3]

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

58 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
jeux18431127(None) 
jeu105532071jeu_
beaux146513212beaux
brux136315272brux
crux135415002crux
dex116936882de_x
doux125817982doux
eaux116618422eaux
ex98835642_e_x
faux146519072faux
feu67843662feu_
feud86523022feud
feus75830752feus
flux145617742flux
geum75424552geum
hex137436172he_x
jauk155816092jauk
jaup135316422jaup
jean116629282jean
jee106648642je_e
jeed125428502jeed
jeep135624842jeep
jeer115426462jeer
jees115938542jees
jeez205622032jeez
jefe146516882jefe
jehu145614862jehu
jehus15488572jehus
jell117125872jell
jeon116821442jeon
jerk154920132jerk
jess116022032jess
jest116738502jest
jet106754822je_t
jete115927252jete
jets115834102jets
jew135129082je_w
jews145822082jews
jinx185516572jinx
jouk156015992jouk
jug115529542j_ug
jun105932062j_un
jus106930222j_us
jut105944012j_ut
kex146029582ke_x
leu36047402leu_
leud57223422leud
lex107943822le_x
lux106528772_lux
neuk87416602neuk
neum66723082neum
redux133811102redux
rex105740992re_x
roux117419362roux
sex107043222se_x
tux105426572_tux
vex136429172ve_x
yeuk116015472yeuk

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 Filter178691298720.280638182.1
2DLD Change Limit29872580.86034734.9
3Display Results58580.0134461.5
 (SQL Overall)178691581.153154979.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.