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

132 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
roux11741936(None) 
doux125817981doux
roue45941741roue
roup66627691roup
rout46153281rout
bout66353292bout
box1210142342bo_x
brux136315272brux
coax136922982coax
coup86729792coup
cox1210346782co_x
croup95616782croup
crux135415002crux
doum76226672doum
dour56330432dour
drouk1039432drouk
eaux116618422eaux
faux146519072faux
flux145617742flux
fou66743782fou_
foul77027582foul
four76226862four
fox136737862fo_x
gout56646002gout
gox117137182go_x
group85413922group
grout65330422grout
hoax147718292hoax
hour75827312hour
jeux184311272jeux
jouk156015992jouk
loud55228042loud
loup66028432loup
lour45430682lour
lout45952142lout
lox108240962lo_x
lux106528772_lux
moue65835572moue
noun45724182noun
nous46136982nous
oryx14510212oryx
oud47439072_oud
our36042892_our
out38072152_out
ox98242382_o_x
pouf95732642pouf
pour611527472pour
pout65752552pout
pox126140692po_x
proud84615482proud
rax108445722r_ax
redux133811102redux
rex105740992r_ex
rhus75114052rhus
road56332112road
roam67132412roam
roan47234202roan
roar46328572roar
rob56754302ro_b
robe65335642robe
robs65837872robs
roc520243252ro_c
rock105735182rock
rocs65533662rocs
rod47953892ro_d
rode55844302rode
rods56442062rods
roe36861082ro_e
roes45954142roes
rogue66417532rogue
roil46235292roil
role45851822role
rolf75134872rolf
roll46331652roll
rom59855632ro_m
romp85926572romp
roms67038962roms
rood56733002rood
roof75738832roof
rook85532032rook
room66235082room
root45655922root
rope65542912rope
ropy96323412ropy
roque144812132roque
rose46148902rose
rosy76024872rosy
rot37282952ro_t
rota45834342rota
rote46249022rote
roti46332932roti
rotl45029682rotl
roto45935052roto
rots46454092rots
rouen54920902rouen
roues56039352roues
rouge65423442rouge
rough97819442rough
round64318432round
roups75118902roups
roupy106112712roupy
rouse56634702rouse
roust55532062roust
route55132072route
routh86423072routh
routs57133412routs
rove75136982rove
row67453672ro_w
rows75941752rows
rub56342822r_ub
rue35549262r_ue
rug46039152r_ug
rum56644642r_um
run36244992r_un
rut35560522r_ut
sou37853692sou_
souk86127172souk
soul46435712soul
soup66232912soup
sour45935892sour
sous46947212sous
sox106444192so_x
tour45530382tour
tout46753822tout
trout57332572trout
tux105426572_tux
vox136628152vo_x
vrouw11507342vrouw
you66641822you_
your78623432your
yous76230652yous
zouk174413542zouk

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 Limit298721320.93631914.5
3Display Results1321320.0334000.0
 (SQL Overall)1786911321.249143067.3
 
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.