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

167 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
rotters7442139(None) 
cotters94323451cotters
dotters83715971dotters
jotters143413801jotters
lotters73921061lotters
otters64021511_otters
potters94024341potters
ratters74422471ratters
ritters74020621ritters
rooters74522931rooters
rosters73727551rosters
rotter64325461rotter_
rottes64524831rotte_s
routers74822871routers
totters74618731totters
trotters83310251trotters
batters94626022batters
betters94422092betters
bitters94920362bitters
blotters104110982blotters
boaters93419242boaters
bolters94017802bolters
bothers124317752bothers
bottlers103810012bottlers
brothers133410832brothers
butters94521722butters
coaters93525792coaters
colters93522442colters
cooters94525732cooters
copters113621282copters
costers94128342costers
cottars94412242cottars
cotter84926672cotter_
cottiers10399162cottiers
couters93827302couters
critters103511332critters
crofters13358912crofters
cutters94218962cutters
doters74423912do_ters
dottels8327782dottels
dotter74419342dotter_
fetters103517902fetters
fitters104517752fitters
footers104618332footers
fosters104220102fosters
fretters113410302fretters
fritters113810782fritters
frothers14279812frothers
frotteurs1242222frotteurs
garotters1055042garotters
getters84216102getters
goiters84014442goiters
gritters94210632gritters
grouters95910092grouters
gutters83715512gutters
hatters104221522hatters
hitters104717592hitters
hooters104520482hooters
hotter94720082hotter_
jitters144314472jitters
jolters143711992jolters
jotter134315632jotter_
knotters12276152knotters
letters73819852letters
litters73422572litters
lofters103912902lofters
loiters74116612loiters
looters74419162looters
lotter64025602lotter_
lottery10389832lottery
lottes65322752lotte_s
matters94421752matters
molters93816972molters
mooters93818622mooters
mothers123717622mothers
mottes85523692motte_s
mottlers10388182mottlers
mutters94117142mutters
natters73718062natters
netters73618582netters
noters64021002no_ters
nutters74215432nutters
oaters65029792_oaters
others93918002_others
ottars64112222_ottars
otter54423972_otter_
outers64230172_outers
oxters134813272_oxters
patters94825192patters
petters93722362petters
plotters104011552plotters
porters93722702porters
posters93928012posters
pothers123818622pothers
potter83926982potter_
pottery123011072pottery
potzers184010542potzers
pouters94221872pouters
powters124015662powters
putters94219192putters
rafters103715632rafters
ranters73323642ranters
rasters74629022rasters
raters63936582r_aters
rattens74213402rattens
ratter64326312ratter_
rattlers83510292rattlers
renters74224822renters
resters74130402resters
reutters8138572reutters
rioters73615522rioters
ritter63822422ritter_
roamers93713462roamers
roarers73812742roarers
roasters83615932roasters
robbers112814162robbers
rockers133916552rockers
rogers74517912ro_gers
roisters83615562roisters
rolfers104011812rolfers
rollers73117472rollers
rompers113412242rompers
roofers105013902roofers
roomers95416412roomers
roosers74217882roosers
roosters83514672roosters
rooter64926032rooter_
ropers84325902ro_pers
roster64329082roster_
rotates72819772rotate_s
rotators8310202rotators
rotes56143902ro_te_s
rotifers1136042rotifers
rotors64917952ro_tors
rotte54625932rotte__
rotted74524432rotte_d
rotten64115432rotte_n
rousers75220142rousers
rousters84315682rousters
router65025842router_
routes66129312route_s
rovers95423522ro_vers
rowers94924572ro_wers
roysters113610532roysters
rozzers1535632rozzers
setters73822062setters
sitters74221552sitters
slotters84012402slotters
sorters74221132sorters
souters74422602souters
spotters104313382spotters
swotters11448482swotters
tatters74520482tatters
tetters74320472tetters
titters74219622titters
tooters73818772tooters
toters65026362to_ters
totter65021462totter_
tottery10388482tottery
touters74018352touters
trotter73312252trotter_
utters63817122_utters
vetters104016322vetters
voters95017442vo_ters
wetters103817752wetters
yatters103914622yatters
zosters163015412zosters

Search took 4 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 Filter1786911076710.403443402.0
2DLD Change Limit1076711673.45631154.8
3Display Results1671670.0602783.3
 (SQL Overall)1786911673.91945596.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.