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

189 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
ratters7442247(None) 
batters94626011batters
hatters104221521hatters
matters94421751matters
natters73718061natters
patters94825191patters
rafters103715631rafters
ranters73323641ranters
rasters74629021rasters
raters63936571ra_ters
rattens74213401rattens
ratter64326311ratter_
rattlers83510291rattlers
ritters74020611ritters
rotters74421391rotters
tatters74520481tatters
yatters103914621yatters
afters94717072_afters
alters64924222_alters
asters65631602_asters
attars64515312_attars
baiters94619302baiters
banters94623112banters
barters94223032barters
basters94930302basters
bathers124720362bathers
battens95313262battens
batter84928872batter_
battery124911812battery
battlers104110972battlers
betters94422092betters
bitters94920352bitters
blatters104414092blatters
butters94521712butters
canters94827722canters
carters95327242carters
casters94729892casters
caters85336492ca_ters
cattery123811602cattery
chatters134213932chatters
clatters103313902clatters
cotters94323432cotters
crafters13419942crafters
craters95021882cra_ters
critters103511312critters
cutters94218952cutters
darters84017602darters
daters74827362da_ters
dotters83715972dotters
drafters12338522drafters
easters75125682easters
eaters65535942ea_ters
falters103916472falters
fathers133916502fathers
fattens105111712fattens
fatter94523212fatter_
fetters103517902fetters
fitters104517742fitters
flatters113814202flatters
fraters103517202fra_ters
fretters113410302fretters
fritters113810782fritters
gaiters83516532gaiters
garters84218222garters
gasters85624282gasters
gaters74728632ga_ters
gathers114315062gathers
getters84216092getters
grafters12409182grafters
granters93614132granters
graters85419732gra_ters
gritters94210632gritters
gutters83715502gutters
hafters134614332hafters
halters104619802halters
haters94930392ha_ters
hatter94724872hatter_
hitters104717582hitters
jitters144314462jitters
jotters143413802jotters
kraters114212332kra_ters
lasters75627692lasters
lathers104321882lathers
lattens75014672lattens
latter65027892latter_
lattes65324202latte_s
letters73819852letters
litters73422562litters
lotters73921062lotters
masters94628922masters
maters85032382ma_ters
matter84325342matter_
mattery123810712mattery
mattes85624532matte_s
mutters94117132mutters
natter64420742natter_
netters73618582netters
nutters74215422nutters
oaters65029782oa_ters
otters64021512_otters
palters94021682palters
pasters94531732pasters
paters84935822pa_ters
pattens95414922pattens
patter84628262patter_
pattern93712052pattern
patterns10439942patterns
patzers184210572patzers
petters93722362petters
platters103415282platters
potters94024342potters
praters94921642pra_ters
prattlers11195322prattlers
putters94219182putters
racers84725432ra_cers
rackers134320452rackers
rafter94517582rafter_
raiders84615142raiders
railers74420662railers
raisers73617392raisers
rakers104123572ra_kers
rammers113715042rammers
rangers83621042rangers
rankers113217462rankers
ranter63826822ranter_
rapers84327182ra_pers
rapiers95012872rapiers
rappers113618442rappers
raptors94213352raptors
rasers64526782ra_sers
rashers104020902rashers
raspers94415912raspers
raster64731442raster_
ratels64518212ra_tels
rater54943282ra_ter_
rates55352012ra_te_s
rather94319732rather_
ratites74920682ratite_s
rattans73411952rattans
ratted74923342ratte_d
ratteen7329112ratteen
ratteens8256052ratteens
ratten64217382ratte_n
ratteners9237262ratteners
rattier74015592rattier_
rattler74012742rattler_
rattles73217302rattles
rattons73815322rattons
ravers94628182ra_vers
razers154919612ra_zers
realters83614042realters
renters74224812renters
resters74130402resters
reutters8138562reutters
rioters73615502rioters
ritter63822412ritter_
roasters83615912roasters
rooters74522932rooters
rosters73727532rosters
rotter64325462rotter_
rottes64524832rotte_s
routers74822852routers
salters73622252salters
scatters103612752scatters
setters73822062setters
shatters113313902shatters
sitters74221542sitters
smatters104011712smatters
spatters103914702spatters
staters73922322staters
swatters113911792swatters
tasters74225642tasters
taters64932192ta_ters
tatter64024572tatter_
tattlers8369692tattlers
tetters74320472tetters
titters74219612titters
totters74618732totters
trotters83310232trotters
utters63817112_utters
vetters104016312vetters
wafters134112812wafters
waiters104218622waiters
wanters104420092wanters
wasters104026592wasters
waters95030622wa_ters
watter93221982watter_
wetters103817752wetters
yatter94116212yatter_

Search took 5 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.1231452772.4
2DLD Change Limit1076711894.17325801.8
3Display Results1891890.0762486.8
 (SQL Overall)1786911894.37240871.7
 
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.