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

426 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
rootling926995(None) 
footling12239921footling
rooting83522431root_ing
tootling9279521tootling
boodling121910242boodling
booting103821362boot_ing
bottling11279142bottling
cooling103422572coo_ling
doodling11218402doodling
drooling102610422droo_ling
fooling113117372foo_ling
footing115017592foot_ing
foozling21275722foozling
hooting113919882hoot_ing
jostling16207122jostling
looting83019642loot_ing
mooting103019362moot_ing
mottling11197752mottling
noodling10209442noodling
pooling103219092poo_ling
rattling92510872rattling
reoiling93217212reoiling
rioting82716392riot_ing
rockling15259382rockling
roiling83220452r_oiling
rolling83620412r_olling
roofing113814352roo_fing
roofline1136192roofline
rooking123517362roo_king
rooming104117042roo_ming
roosing84018132roo_sing
roosting93411462roosting
rootlike1236612rootlike
rotting82919682r_otting
routing83821092rout_ing
roweling122811122roweling
rustling9249982rustling
soothing12269972soothing
sooting82820962soot_ing
tooling82918312too_ling
toothing12278862toothing
tooting83019422toot_ing
bantling112612003bantling
battling113110493battling
beetling1139283beetling
blotting113910433blotting
boating103721303boat_ing
bobbling12238643bobbling
boggling13257163boggling
boiling103819673_boiling
bolling103820883_bolling
bolting104416763bolt_ing
boobing123613913boo_bing
boogying1535373boogying
booing94521643boo__ing
booking143618383boo_king
booming123716223boo_ming
boosting113311053boosting
bootleg10276633bootl_eg
bootlick1664643bootlick
boozing194012163boo_zing
bottlings12215293bottlings
boweling143410683boweling
bowling133916493_bowling
brattling1236003brattling
bristling1246663bristling
brittling1235543brittling
broiling113112013broiling
brooding122911373broo_ding
brooking153710703broo_king
brooming132911143broo_ming
bustling112110063bustling
butling103516813_butling
castling11311233castling
catling104819793_catling
chitling142910663chitling
chortling1535563chortling
clothing14278783clothing
clotting113110643clotting
coaling103722823_coaling
coating103525313coat_ing
cobbling15248803cobbling
cockling172310393cockling
coddling13258473coddling
codling114418953_codling
coffling1736483coffling
coiling103723453_coiling
cooeeing1137453cooeeing
cooeying1438143cooeying
cooing94024923coo__ing
cooking143818973coo_king
cooping123918933coo_ping
coopting133411313coopting
costing104323023cost_ing
coting94629253_cot_ing
coupling13310783coupling
cowling134017423_cowling
crooking153611343croo_king
crooning113112113croo_ning
cuttling1138203cuttling
dartling1039563dartling
doating93816863doat_ing
doling84923133_do_ling
dolling93817373_dolling
dooming113112533doo_ming
doting84821913_dot_ing
dotting93314483_dotting
doubling1238153doubling
doweling13279763doweling
drolling103510763drolling
drooping12268803droo_ping
emoting10313563emot_ing
enrooting10128133enroot_ing
fatling113815683_fatling
fettling1266773fettling
flatling123410013flatling
foaling113515843_foaling
foiling113317653_foiling
fondling13189353fondling
footings12248833foot_ings
footlike1537253footlike
fouling113315373_fouling
fowling143713113_fowling
fronting12310443front_ing
frontline1245053frontline
frosting12311183frost_ing
frostline1245883frostline
frothing15208533frothing
gaoling93314653gao_ling
gentling1048453gentling
goaling93515333_goaling
gobbling14257533gobbling
godling103513403_godling
goggling10246283goggling
goofing123510633goo_fing
goosing93314083goo_sing
gosling93312403_gosling
grooming12309513groo_ming
grooving13286713groo_ving
grouting103410793grout_ing
groveling1435573groveling
growling1348163growling
gruntling1134263gruntling
guttling1037293guttling
hobbling16227583hobbling
hogtying1633553hogtying
holing104025073_ho_ling
hondling132210013hondling
hooding123815203hoo_ding
hoofing143912553hoo_fing
hooking153716693hoo_king
hooping133615703hoo_ping
hoppling16206763hoppling
hosteling1337893hosteling
hosting114318383host_ing
hotline10712353_hotline
hotlink1476763_hotlink
hotting113116523_hotting
hoveling15189593hoveling
howling143413163_howling
hurtling12318313hurtling
hustling12228793hustling
joggling18215573joggling
jolting153410913jolt_ing
jotting152912773_jotting
justling16207253justling
kitling123313573_kitling
kittling1336063kittling
knolling13206893knolling
knotting13236573knotting
kotowing1634013kotowing
loathing1247673loathing
lofting113311313loft_ing
lolling83415783_lolling
looing73621043loo__ing
looking123415043loo_king
looming102814853loo_ming
looping103615283loo_ping
loosing83515963loo_sing
lordling1077743lordling
lotting82917753_lotting
louting83719383lout_ing
mantling112012613mantling
moating104218153moat_ing
modeling12311073modeling
moiling103417663_moiling
molting103517173molt_ing
mooching16259063mooching
mooing93718373moo__ing
mooning103415553moo_ning
mooring102514443moo_ring
motoring11410953motoring
moulting112710313moulting
mouthing142810243mouthing
nestling958893nestling
nettling957213nettling
nobbling13228273nobbling
noddling11237263noddling
noncling11310763noncling
noodging11185693noodging
nooning83014853noo_ning
noosing83315053noo_sing
northing12199063northing
nothing113511903_nothing
noting74120153_not_ing
ogling83211883__ogling
oiling74925313__oiling
oodlins83210513_oodlins
oohing104412933_oo_hing
oolong738073_oo_long
oozing163812203_oo_zing
opting94514403_opt_ing
orating83520323orat_ing
outing74128153_out_ing
outline72321333_outline
outlying1248813_outlying
outring84021023_outring
outsing83320463_outsing
peopling1338353peopling
pestling111010253pestling
pettling1168213pettling
photoing1439073photoing
plotline1037643plotline
plotting113011013plotting
plotzing20276153plotzing
poling93526503_po_ling
polling102920383_polling
pooching16328983pooching
poohing133112323poo_hing
pooing93820683poo__ing
pooping123615443poo_ping
poppling12227323poppling
porting103021783port_ing
posting105622243post_ing
potline91015233_potline
potting103720893_potting
pouting103519943pout_ing
prattling1246303prattling
profiling1548233profiling
promoting1439923promot_ing
proofing1439313proo_fing
prowling1449993prowling
quoting17310043quot_ing
rabbling13239333rabbling
raddling11229773raddling
raffling1567063raffling
rafting113815753raft_ing
railing83325643r_ailing
rambling131810773rambling
rankling132610113rankling
ranting84025413rant_ing
rassling939013rassling
rating74938703r_at_ing
ratlin64116523r_atlin_
ratline74517803r_atline
ratlins73615583r_atlins
ratting83822363r_atting
rattlings10235513rattlings
raveling123414373raveling
reboiling12149823reboiling
rebooting12139023reboot_ing
rebottling1343733rebottling
recoaling121312453recoaling
recoiling121412413recoiling
reddling112911813reddling
reedling102414273reedling
reeling83126863r_eeling
refiling123116533refiling
regaling10315363regaling
renting84026853rent_ing
repolling122110203repolling
repotting12511123repotting
rerolling102210373rerolling
resiling93520173resiling
resoling92916303resoling
resting85031183rest_ing
restring91518783restring
restyling1337923restyling
retiling93319483retiling
retitling1039773retitling
retooling1039093retooling
retotaling1186883retotaling
retting83425883r_etting
retying113213833r_etying
reveling123117083reveling
reviling122917213reviling
revolting1339633revolting
revoting12312033revot_ing
riddling11249443riddling
ridgling11258203ridgling
riesling939013riesling
riffling1556113riffling
rifling112815013r_ifling
rifting113515003rift_ing
riling74227973r__iling
rilling84023623r_illing
rimpling13219663rimpling
rippling13197573rippling
rivaling1239913rivaling
roaching143210433roaching
roaming103215793r_oaming
roaring82916003r_oaring
roasting93012703roasting
robbing123313213r_obbing
robing93618003r_o_bing
robotizing2245553robotizing
rocking143619633r_ocking
rocklings16224843rocklings
rodding103814533r_odding
rodeoing1037253rodeoing
rogering10310273rogering
rogueing1054313rogueing
roguing9309563r_oguing
rolfing113710653r_olfing
rollings9419953r_ollings
romping123113033r_omping
roofings12256023roo_fings
rooflike1534623rooflike
rooflines1245373rooflines
rootier74915393root_ier
rootle63214453rootl__e
rootled83410533rootl_ed
rootles73215633rootl_es
rootless83910443rootless
rootlet73015733rootl_et
rootlets8308653rootlets
roping94023023r_o_ping
rosing73925593r_o_sing
rosining92411423rosining
rotating92614553rotating
rototilling1252643rototilling
roughing13278343roughing
rouging93114703r_ouging
rounding102812283rounding
rouping103715793r_ouping
rousing83920553r_ousing
rousting93913273rousting
routine72615903rout_ine
roving103618743r_o_ving
rowelling1366993rowelling
rowing103623303r_o_wing
rubbling13238073rubbling
ruckling15258573ruckling
ruddling11228553ruddling
ruffling1546093ruffling
ruling73219553r__uling
rumbling131910103rumbling
rumpling13178763rumpling
runkling13217613runkling
rusting83821263rust_ing
rutting82718043r_utting
scooting113012643scoot_ing
scowling1458293scowling
settling978943settling
shoaling123111753shoaling
shooling123012563shooling
shooting122812863shoot_ing
shotting123012383shotting
skoaling13227213skoaling
slotting92612613slotting
smoothing1535293smoothing
snooling93013473snooling
snooting92813203snoot_ing
snoozling19314343snoozling
soiling83422323_soiling
soling74226823_so_ling
sorting83221813sort_ing
southing122811823southing
spoiling112911553spoiling
spooling113212563spooling
spotting112812093spotting
stooling93113133stooling
stotting92811163stotting
swotting12268483swotting
tattling9259473tattling
tholing112812333tho_ling
throttling1442793throttling
titling83715793_titling
toddling11187003toddling
toggling11206483toggling
toiling83219023_toiling
toiting83217093toit_ing
toling73926123_to_ling
tolling83418563_tolling
toolings9248473too_lings
toppling13197353toppling
totaling9610303totaling
toting74123793_tot_ing
totting82816843_totting
tousling938793tousling
touting84118453tout_ing
touzling1835503touzling
toweling122910373toweling
trolling93212493trolling
trooping112710283troo_ping
trothing122410843trothing
trotline8310023trotline
trotting92510913trotting
troubling1234943troubling
troweling1376363troweling
turtling9238833turtling
unrooting1098833unroot_ing
uprooting1276903uproot_ing
vittling1236143vittling
voling103918023_vo_ling
voting103916033_vot_ing
vrooming14287353vroo_ming
wattling12258783wattling
wintling12249923wintling
witling113215813_witling
wobbling16246923wobbling
wonting113214103wont_ing
wooding123012023woo_ding
woofing14349893woo_fing
wooing104214663woo__ing
woopsing1435633woopsing
wooshing1536683wooshing
worthing15178053worthing
wotting112913843_wotting
wrastling1335523wrastling
wrestling1336063wrestling
yodeling1357673yodeling
yodling123610253_yodling
yowling143610223_yowling
zooming19269653zoo_ming
zooning172910703zoo_ning

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.423422437.4
2DLD Change Limit1461624266.89021213.6
3Display Results4264260.1732462.4
 (SQL Overall)1786914267.48623870.0
 
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.