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

152 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
rooses6552623(None) 
gooses75723051gooses
looses67328241looses
nooses65623641nooses
roose56127091roose_
roosed75621591roosed
rooser63921881rooser
roosers74217871roosers
roosts64916321roosts
roses56445771r_oses
rouses65436281rouses
arkoses113910832arkoses
arouses74921292arouses
boosts86115012boosts
boozes174916522boozes
bosses85925402bosses
bouses84931782bouses
bowses115718862bowses
broses86524402broses
browses124712692browses
chooses125717422chooses
choses115825132choses
closes85425592closes
cooees85621892cooees
copses104922472copses
corses84433462corses
coses76949492_coses
crosses94220792crosses
doses65938502_doses
dosses76126272dosses
douses74928932douses
dowses105718302dowses
drosses84513822drosses
drowses114610232drowses
eposes84418782eposes
eroses65327052eroses
fosses96022082fosses
gnoses76515162gnoses
goose65925902goose_
goosed86817032goosed
goosey105913512goosey
gorses74723292gorses
grooves11368802grooves
grosses84517682grosses
grouses84616542grouses
hoises94823672hoises
hooves124815482hooves
horses94729342horses
hoses85443172_hoses
houses96032272houses
josses135117682josses
looies65025832looies
loose56627682loose_
loosed75520892loosed
loosen66615962loosen
loosens716310952loosens
looser65219942looser
loosest75811562loosest
loses56742012_loses
losses65925232losses
lotoses73713642lotoses
louses66230282louses
mioses84318852mioses
moose76327192moose_
mosses85527682mosses
mouses85531422mouses
myoses114013842myoses
noises65021852noises
noose55624062noose_
noosed75018012noosed
nooser65517822nooser
noosers74913922noosers
noses55435642_noses
nouses64627162nouses
oases55330982_oases
oozes145418712_oozes
oses46641512__oses
poises84226542poises
pooves113914712pooves
poses74642762_poses
posses85128802posses
proposes122515972proposes
proses84733472proses
prosses94019512prosses
ptoses83514672ptoses
pyoses114314302pyoses
raises64826542raises
rases55447212r_ases
reposes94021262reposes
reuses66025522reuses
rhuses94911792rhuses
riboses9310442riboses
rinses64720382rinses
rises55244042r_ises
roasts64915412roasts
robes75133302r_obes
robles85321692robles
rodes614039082r_odes
roes45954142r_o_es
rogues74617672rogues
roles56747982r_oles
roods65125282roo_ds
roofed105214742roofed
roofer94415282roofer
roofers105013902roofers
roofies103014412roofies
roofs85321152roo_fs
rooked114918142rooked
rookies113917102rookies
rooks95325042roo_ks
roomed95218542roomed
roomer84718632roomer
roomers95416412roomers
roomies93017242roomies
rooms75324682roo_ms
roost55730932roos_t
roosted83211882roosted
rooster74415172rooster
roosters83514662roosters
rooted75424002rooted
rooter64926032rooter
rooters74522932rooters
rootles73215632rootles
roots55933672roo_ts
ropes75940062r_opes
roques154912562roques
rose46148902r_ose_
rosed65930342r_osed
roset55945242r_oset
rosets65819952r_osets
rotes56143902r_otes
rottes64524832rottes
roues56039352r_oues
rouges76022382rouges
rouse56634702rouse_
roused75426442roused
rouser65224082rouser
rousers75220142rousers
rousts617016722rousts
routes66129312routes
roves84834482r_oves
ruses56136582r_uses
soroses73117482soroses
souses64229242souses
tootses72910772tootses
torses64727952torses
tosses65225392tosses
touses64229672touses
trioses75015652trioses
woopses1237882woopses
wooshes13169882wooshes
worses95522952worses

Search took 6 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.686260482.5
2DLD Change Limit825511524.94016710.7
3Display Results1521520.0463304.3
 (SQL Overall)1786911525.67231504.1
 
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.