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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
rouges7602238(None) 
gouges86318691gouges
rogues74617671rogues
roues56039351rou_es
rouge65423441rouge_
rouged86717321rouged
roughs105416211roughs
rouses65436281rouses
routes66129311routes
arouses74921292arouses
boughs125414372boughs
bougies103715182bougies
boules84925972boules
bouses84931782bouses
brogues10719822brogues
conges94928172conges
coughs125514542coughs
coupes105022522coupes
croupes114613102croupes
croutes94815652croutes
dodges96119072dodges
doges75630162do_ges
doughs115912932doughs
douses74928932douses
drogues9398392drogues
forges105024262forges
gauges85915992gauges
gorges85321892gorges
gouge78220062gouge_
gouged96214592gouged
gouger86014362gouger
gougers94911762gougers
grouses84616542grouses
houses96032272houses
joules134116822joules
kluges11389562kluges
lodges86820142lodges
loges66534202lo_ges
longes75925572longes
loughs105014772loughs
louies64525102louies
lounges84811352lounges
loupes84918052loupes
louses66230282louses
luges65928752_luges
moues75732842mou_es
mouses85531422mouses
nouses64627162nouses
rages64539442r_ages
ranges73826922ranges
refuges115413372refuges
reges65628782r_eges
reuses66025522reuses
rhuses94911792rhuses
ridges85817002ridges
robes75133302ro_bes
robles85321692robles
rodes614039082ro_des
roes45954142ro__es
roger64521412ro_ger
rogers74517912ro_gers
rogue66417532rogue_
rogued84711472rogued
roles56747982ro_les
rooses65526232rooses
ropes75940062ro_pes
roques154912562roques
roses56445772ro_ses
rotes56143902ro_tes
rottes64524832rottes
roubles93413512roubles
rouches124217892rouches
roue45941742rou_e_
rouen54920902rou_en
rouens64814442rouens
rough97819432roug_h
roughed124210942roughed
roughen11338832roughen
roughens12286892roughens
rougher113511032rougher
roughers12329182roughers
roughest1238772roughest
roughies1298322roughies
roughy137010852roughy
rounds73615622rounds
rouped95717352rouped
roupet84218342roupet
roups75118902rou_ps
rouse56634702rouse_
roused75426442roused
rouser65224082rouser
rousers75220142rousers
rousts617016722rousts
route55132072route_
routed75624332routed
router65025842router
routers74822872routers
rouths95416822rouths
routs57133412rou_ts
roves84834482ro_ves
rubes74928412r_ubes
rues46044482r_u_es
rugs56033682r_ug_s
rules55234252r_ules
runes55530222r_unes
ruses56136582r_uses
scrouges1136682scrouges
soughs105115622soughs
souses64229242souses
togues76014242togues
toughs105414982toughs
touses64229672touses
troughs11698682troughs
troupes94112852troupes
vogues104011922vogues
wodges117413672wodges

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825511162.48333246.5
3Display Results1161160.0333515.2
 (SQL Overall)1786911162.62668046.8
 
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.