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

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

495 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
rattlers8351029(None) 
battlers104110971battlers
prattlers11195321prattlers
ratters74422471ratt_ers
rattler74012741rattler_
rattles73217301rattle_s
tattlers8369691tattlers
antlers74014742_antlers
batters94626012batt_ers
battler94113382battler_
battles94517682battle_s
bottlers103810012bottlers
brattles10199332brattle_s
guttlers9306922guttlers
hatters104221522hatt_ers
matters94421752matt_ers
mottlers10388182mottlers
natters73718062natt_ers
nettlers8307512nettlers
patters94825192patt_ers
prattler10166342prattler_
prattles10189402prattle_s
rabblers123810852rabblers
rafflers14317362rafflers
rafters103715632raft_ers
railers74420662ra_ilers
ramblers124010372ramblers
ranters73323642rant_ers
rasters74629022rast_ers
raters63936572ra_t_ers
ratteens8256052ratteens
ratteners9237262ratteners
rattens74213402ratt_ens
ratter64326312ratt_er_
rattier74015592rattier_
rattle64717612rattle__
rattled84012952rattle_d
ravelers113310862ravelers
ritters74020612ritt_ers
rotters74421392rott_ers
rustlers8339852rustlers
settlers8289022settlers
tatters74520482tatt_ers
tattler73112212tattler_
tattles73616282tattle_s
wattles103814072wattle_s
wattless11268722wattless
yatters103914622yatt_ers
aethers103614943_aethers
afters94717073_aft_ers
alters64924223_alt_ers
amblers115213563_amblers
anglers84014823_anglers
anthers103715203_anthers
antler64615553_antler_
artless73712513_artless
ashlers10319583_ashlers
asters65631603_ast_ers
ateliers837883_ateliers
atoners75013953_atoners
attars64515313_att_ars
attires72312953_attires
babblers113510353babblers
bafflers16356593bafflers
bailers94221353ba_ilers
baiters94619303bait_ers
balers85626933ba__lers
ballers94421013ba_llers
banters94623113bant_ers
barters94223033bart_ers
basters94930303bast_ers
batchers153613273batchers
bathers124720363ba_thers
bathless13127383bathless
batteners11238163batteners
battens95313263batt_ens
batter84928873batt_er_
batterers113110713batterers
battery124911813batt_ery
battier93515713battier_
battle85217863battle__
battled104213123battle_d
battues94610193battue_s
bawlers124412733ba_wlers
beetlers1037393beetlers
betters94422093bett_ers
bitters94920353bitt_ers
blatters104414093blatt_ers
bottler94211883bottler_
bottles94216273bottle_s
brabblers12335563brabblers
bractless1335543bractless
bractlets1344753bractlets
braillers1135553braillers
brattier1047663brattier_
brattle9249253brattle__
brattled11196723brattle_d
brawlers13408643bra_wlers
brittler10165983brittler_
brittles10178653brittle_s
bustlers104210613bustlers
butlers94518053_butlers
butters94521713butt_ers
cablers114416713ca_blers
cacklers163710703cacklers
cajolers17267133cajolers
callers94221963ca_llers
candlers114214103candlers
canters94827723cant_ers
cantles94721413cantle_s
carolers103314173carolers
carters95327243cart_ers
casters94729893cast_ers
castles94917733castle_s
catchers153114053catchers
caterers102814393caterers
caters85336493ca_t_ers
cattery123811603catt_ery
cattier93317073cattier_
catties94023053cattie_s
cattle85118903cattle__
cattleya1342403cattleya
cattleyas1442623cattleyas
cavilers1348113cavilers
chatters134213933chatt_ers
clatters103313903clatt_ers
cotters94323433cott_ers
cottiers10399153cottiers
cradlers11309183cra_dlers
crafters13419943craft_ers
craters95021883cra_t_ers
crawlers13309003cra_wlers
critters103511313critt_ers
cutlers94216993_cutlers
cutters94218953cutt_ers
cuttles93613923cuttle_s
dabblers13379363dabblers
dandlers103912053dandlers
danglers103610593danglers
darters84017603dart_ers
dartles84014133dartle_s
dateless9259963dateless
daters74827363da_t_ers
dawdlers13375673dawdlers
dazzlers1733233dazzlers
dotters83715973dott_ers
dottles83912283dottle_s
drafters12338523draft_ers
drawlers12307313dra_wlers
easters75125683east_ers
eaters65535943ea_t_ers
fablers124812613fa_blers
fallers103917993fa_llers
falters103916473falt_ers
fartleks1533963fartleks
fathers133916503fa_thers
fatless103212203fa_tless
fatteners12236873fatteners
fattens105111713fatt_ens
fatter94523213fatt_er_
fattier103513463fattier_
fatties103018203fattie_s
fetters103517903fett_ers
fettles103912733fettle_s
fitters104517743fitt_ers
flatters113814203flatt_ers
footlers113910793footlers
fraters103517203fra_t_ers
fretters113410303frett_ers
fritters113810783fritt_ers
gabblers134110083gabblers
gaiters83516533gait_ers
gamblers13369733gamblers
gantlets9308903gantlets
gaolers83511563ga_olers
garblers113810283garblers
garglers10418263garglers
garters84218223gart_ers
gasters85624283gast_ers
gateless9279953gateless
gaters74728633ga_t_ers
gathers114315063ga_thers
getters84216093gett_ers
grabblers14345513grabblers
grafters12409183graft_ers
granters93614133grant_ers
grapplers14274303grapplers
grateless10277573grateless
graters85419733gra_t_ers
gritters94210633gritt_ers
gutters83715503gutt_ers
guttler8369163guttler_
guttles83011933guttle_s
hacklers173710303hacklers
hafters134614333haft_ers
hagglers13326623hagglers
hailers104017263ha_ilers
halers94926913ha__lers
halters104619803halt_ers
haltless11308443haltless
handlers124014143handlers
hantles104117513hantle_s
hatchers163113173hatchers
haters94930393ha_t_ers
hatless103813443ha_tless
hatter94724873hatt_er_
haulers104012443ha_ulers
hitters104717583hitt_ers
hostlers113310483hostlers
hustlers11349203hustlers
jailers144114043ja_ilers
janglers16319373janglers
jitters144314463jitt_ers
jostlers15357683jostlers
jotters143413803jott_ers
kettles113411613kettle_s
kittler11338163kittler_
kittles113012493kittle_s
kraters114212333kra_t_ers
labelers10249413labelers
ladlers84613563la_dlers
landlers94312833landlers
lasters75627693last_ers
lathers104321883la_thers
lattens75014673latt_ens
latter65027893latt_er_
lattes65324203latt_e_s
letters73819853lett_ers
litters73422563litt_ers
littler7348553littler_
littles73212783little_s
lotters73921063lott_ers
mailers94420333ma_ilers
manglers113311903manglers
mantles94820703mantle_s
mantlets104611203mantlets
marblers12319233marblers
martlets103310483martlets
masters94628923mast_ers
mastless102610023mastless
matchers153012433matchers
mateless102711293mateless
maters85032383ma_t_ers
matless93014043ma_tless
matter84325343matt_er_
mattery123810713matt_ery
mattes85624533matt_e_s
mattress1036533mattress
maturers1037373maturers
maulers94213303ma_ulers
mettles94115023mettle_s
mottler94410343mottler_
mottles93415803mottle_s
mutters94117133mutt_ers
nailers73215893na_ilers
nathless11127023nathless
natter64420743natt_er_
nattier73614623nattier_
nestlers8359223nestlers
netters73618583nett_ers
nettler7349503nettler_
nettles73214083nettle_s
nutters74215423nutt_ers
oaters65029783oa_t_ers
ostlers72911203_ostlers
otters64021513_ott_ers
paddlers12329153paddlers
palters94021683palt_ers
panthers13510783panthers
partiers103514243partiers
partlets102811513partlets
partners102711133partners
partyers13277763partyers
pasters94531733past_ers
pastless102411203pastless
patchers153413303patchers
paters84935823pa_t_ers
pathless13138043pathless
pattens95414923patt_ens
patter84628263patt_er_
patterers112410123patterers
pattern93712053patt_ern
patterns10439943patt_erns
patties93425143pattie_s
patzers184210573pa_tzers
petters93722363pett_ers
pettles93916483pettle_s
platters103415283platt_ers
potters94024343pott_ers
pottles93816983pottle_s
praters94921643pra_t_ers
prattle9208833prattle__
prattled11246533prattle_d
putters94219183putt_ers
puttiers10288013puttiers
rabbler113514093rabbler_
rabbles113517973rabble_s
racers84725433ra__cers
rackers134320453ra_ckers
raddles93615703raddle_s
raffler13339223raffler_
raffles133611843raffle_s
rafter94517583raft_er_
raggles93813283raggle_s
raiders84615143ra_iders
railer64524933ra_iler_
raillery1134953raillery
rainless8129703rainless
raisers73617393ra_isers
rakers104123573ra__kers
rales54947493ra__le_s
ralliers84010833ralliers
rambler113313263rambler_
rambles113118313ramble_s
rammers113715043ra_mmers
ranchers133311793ranchers
rangers83621043ra_ngers
rankers113217463ra_nkers
rankles113114543rankle_s
rankless12268233rankless
ranter63826823rant_er_
rapers84327183ra__pers
rapiers95012873ra_piers
rappers113618443ra_ppers
raptness1046733raptness
raptors94213353rapt_ors
raptures1037573raptures
rasers64526783ra__sers
rashers104020903ra_shers
raspers94415913ra_spers
rassles73513923rassle_s
raster64731443rast_er_
ratables10159723ratable_s
ratafees1144143ratafees
ratals64219583ratal__s
ratches123620463ratche_s
ratchets133110263ratchets
ratels64518213ra_t_els
rater54943283ra_t_er_
rates55352013ra_t_e_s
rather94319733ra_ther_
ratholes11312413rathole_s
ratifiers1236453ratifiers
ratines75328583ratine_s
ratites74920683ratite_s
ratlins73615583ra_tlins
ratooners965823ratooners
rattails837133rattails
rattans73411953ratt_ans
ratted74923343ratt_e_d
ratteen7329113ratt_een
ratten64217383ratt_e_n
rattener8238533rattener_
rattiest83516113rattiest
rattlebox1851543rattlebox
rattletrap1251503rattletrap
rattletraps1361503rattletraps
rattling92510873rattling
rattlings10235513rattlings
rattly94111543rattl__y
rattons73815323ratt_ons
rattoons8327513rattoons
rattraps1044813rattraps
ravagers1235573ravagers
raveler104212463raveler_
ravellers12257163ravellers
raveners11309123raveners
ravers94628183ra__vers
rayless10239003ra_yless
razers154919613ra__zers
realters83614043realt_ers
reelers73520273r_eelers
regalers94311123regalers
renters74224813rent_ers
rentiers83311763rentiers
resters74130403rest_ers
restless82713163restless
retailers9258773retailers
retakers123511133retakers
retiles74426993retile_s
retirers84311533retirers
retitles83612593retitle_s
reutters8138563reutters
revelers113414133revelers
revilers114011693revilers
riddlers10269103riddlers
rifflers14336443rifflers
riflers103512193r_iflers
riftless1136943riftless
rioters73615503riot_ers
ripplers12337113ripplers
ritter63822413ritt_er_
roasters83615913roast_ers
rollers73117473r_ollers
rooters74522933root_ers
rootles73215633rootle_s
rootless83910443rootless
rootlets8308653rootlets
rosters73727533rost_ers
rotifers1136043rotifers
rotter64325463rott_er_
rottes64524833rott_e_s
routers74822853rout_ers
rufflers14347193rufflers
rulers64317093r__ulers
rumblers123610743rumblers
rustler73512343rustler_
rustles73416413rustle_s
rustless83510233rustless
ruthless1135413ruthless
rutiles74315843rutile_s
ruttier73412283ruttier_
saddlers10289753saddlers
sailers73822313sa_ilers
salters73622253salt_ers
saltiers83411953saltiers
saltless8259343saltless
samplers12299403samplers
scatters103612753scatt_ers
setters73822063sett_ers
settler73410653settler_
settles73916003settle_s
settlors8255003settlors
shatters113313903shatt_ers
shuttlers1254123shuttlers
sitters74221543sitt_ers
smatters104011713smatt_ers
spatters103914703spatt_ers
sprattles1174883sprattle_s
stablers103611143stablers
staplers103111183staplers
startlers9236733startlers
staters73922323stat_ers
stylers10359343_stylers
sutlers73116973_sutlers
swatters113911793swatt_ers
tacklers143010773tacklers
tactless10288463tactless
tailers73720183ta_ilers
talers64628143__talers
tanglers92911973tanglers
tartlets8289663tartlets
tasters74225643tast_ers
taters64932193ta_t_ers
tatter64024573tatt_er_
tattier74216243tattier_
tatties74120343tattie_s
tattle64115653tattle__
tattled84311483tattle_d
tattooers943633tattooers
tetters74320473tett_ers
throttlers1352483throttlers
tilers63523493__tilers
titters74219613titt_ers
tittles73413253tittle_s
tootlers8289503tootlers
totters74618733tott_ers
trailers82912913tra_ilers
tramplers13305873tramplers
travelers12266773travelers
trawlers113310193tra_wlers
trotters83310233trott_ers
turtlers8258203turtlers
twattles1154383twattle_s
utters63817113_utt_ers
vaulters11206163vaulters
vetters104016313vett_ers
vittles103211113vittle_s
wabblers15398993wabblers
waddlers13298333waddlers
wafflers17306323wafflers
wafters134112813waft_ers
wailers103916803wa_ilers
waiters104218623wait_ers
walers94824463wa__lers
waltzers2034003waltzers
wanglers123310033wanglers
wanters104420093want_ers
warblers13319103warblers
warslers11328073warslers
warstlers12284713warstlers
wartless11279923wartless
wasters104026593wast_ers
watchers163511793watchers
waterers112312783waterers
waters95030623wa_t_ers
watter93221983watt_er_
wattle94314213wattle__
wattled113610503wattle_d
wetters103817753wett_ers
whittlers1594333whittlers
wranglers1344273wranglers
wrastles11328933wrastle_s
wrestlers12306103wrestlers
yatter94116213yatt_er_

Search took 8 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 Filter1786911461620.1561145455.1
2DLD Change Limit1461624957.53019410.6
3Display Results4954950.1862661.3
 (SQL Overall)1786914957.87222699.6
 
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.