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 “ruche” 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.

79 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
ruche10421676(None) 
rouche114714311rouche
ruched124314631ruched
ruches114819581ruches
ache96829822_ache
boche124216952boche
broche133612102broche
cache125122482cache
creche13310762creche
douche124613222douche
duce76933502duc_e
duchy144310872duchy
eche97520282_eche
euchre11137662euchre
fiche134616742fiche
gauche1238552gauche
kuchen1536652kuchen
louche115212662louche
luce65132572luc_e
lucre76415522lucre
mache125925302mache
miche126219242miche
much115224032much_
muches134718992muches
mucho125013442mucho
niche105016792niche
nucha10229792nucha
nuchae11218512nuchae
orache114013592orache
ouch95724632ouch_
ouched124316932ouched
ouches114322182ouches
ouphe104413262ouphe
puce85127882puc_e
quiche2057902quiche
race66746262rac_e
rachet115028972rachet
raphe104916422raphe
rathe85821922rathe
recce9514562recce
rechew14310212rechew
rice64942912ric_e
rich97025542rich_
richen113812512richen
richer114015042richer
riches115022082riches
rochet115423002rochet
rotche114311982rotche
rouches124217892rouches
rube65532012ru_be
ruble74521252ruble
ruck104728332ruc_k
rucked134718762rucked
ruckle124414582ruckle
rucks114422052rucks
rude55632782ru_de
rue35549262ru__e
ruffe114713812ruffe
rugae65114762rugae
rule49938422ru_le
rune45236292ru_ne
rupee7321282rupee
ruse45938932ru_se
rush76628182rush_
rushed104419862rushed
rushee93818772rushee
rusher94019652rusher
rushes94724362rushes
rushy115414812rushy
ruth76825992ruth_
ruths85714642ruths
such96424812such_
sucre75019102sucre
tache106222372tache
touche114916172touche
troche113112512troche
truce75118692truc_e
tusche1136782tusche
yuch125818532yuch_

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 Limit53800791.56334421.0
3Display Results79790.0164937.5
 (SQL Overall)178691791.672106872.6
 
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.