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

472 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
roomie8301387(None) 
roofie93411171roofie
rookie103613261rookie
roomier93812241roomier
roomies93017241roomies
anomie83215962anomie
boobie104015292boobie
boogie93515992boogie
bookie123516002bookie
boomier113312182boomier
bootie85421162bootie
brookie1347372brookie
broomier1236872broomier
commie124215522commie
cookie123716042cookie
coolie83821602coolie
coombe124110092coombe
cootie84223092cootie
doobie94712682doobie
doolie73916832doolie
doomier103610122doomier
doozie163910652doozie
dormie9312622dormie
foodie104413842foodie
footie94718142footie
goodie83613992goodie
goonie73615562goonie
homie104622532_homie
hoodie105116142hoodie
hoolie93217782hoolie
kookie9389842kookie
looie55624242loo_ie
loonie64216452loonie
noogie73612312noogie
nookie103712432nookie
oorie53026362_oorie
pommie123710502pommie
ramie75027822r_amie
roadie72813812roadie
roofies103014412roofies
rookier114012382rookier
rookies113917102rookies
room66235082room__
roomed95218542roomed
roomer84718632roomer
roomiest102611992roomiest
roomily1237282roomily
rooming104117042rooming
rooms75324682room_s
roomy107118062room_y
roose56127092roo_se
rootier74915392rootier
rootle63214452rootle
toonie63617992toonie
woodie103513612woodie
woolie93514482woolie
amie66339853__amie
anomic102516303anomic
anomies93316993anomies
atomic104115603atomic
atomies93918363atomies
atomise93013823atomise
atomize183111823atomize
barmie103816393barmie
biome94916993biom_e
blooie83913193blooie
bloomier1275783bloomier
boccie123311453boccie
bogie89524103_bogie
bombe115519313_bombe
bonhomie1555213bonhomie
bonnie85314853bonnie
boobies113718203boobies
boodies103721443boodies
boodle93215033boodle
boogied11379283boogied
boogies103719013boogies
bookies133819403bookies
boom87435673boom__
boomed115318133boomed
boomer104618513boomer
boomiest122711843boomiest
booming123716223booming
boomkin1545363boomkin
boomlet112412273boomlet
booms95427123boom_s
boomy125421823boom_y
boonies93422483boonies
bootee84323023bootee
booties94124613booties
booze164718913boo_ze
boozier18349013boozier
bougie93613273bougie
brome94421973brom_e
bromic122412693bromic
bromid112612893bromid
bromide12269583bromide
bromin102615693bromin
bromine112915243bromine
bromize20238823bromize
broodier1157433broodier
brookies1459143brookies
brookite1445503brookite
broom95022213broom__
broomed124111053broomed
broomiest1356913broomiest
brooming132911143brooming
brooms104915873broom_s
broomy13449953broom_y
brownie12178433brownie
cammie124615293cammie
collie83621993collie
comae97128423_comae
combe116223543_combe
come87547703_com_e
comic114721813_comic
comix163513203_comix
commies133718453commies
commit124016703commit
commix19407763commix
comose105016843comose
comte96125473_comte
cooee74531023coo_ee
cookies133719273cookies
coolies93824963coolies
coomb115615703coom_b
coombes133810663coombes
coombs124210193coombs
coontie9311423coontie
cooties93725733cooties
corbie103618203corbie
corrie83621223corrie
cosie74728263_cosie
cosmic12410343cosmic
cosmid11810643cosmid
cowpie133511513cowpie
cowrie113814283cowrie
cozie163519133_cozie
croppie13278793croppie
crowdie1335913crowdie
crummie1336153crummie
dhootie1136473dhootie
dobie84920333_dobie
doggie93910893doggie
dogie75222793_dogie
dolomite1148133dolomite
dome77240733_dom_e
domic104317243_domic
domine92918253_domine
donsie7613643donsie
doobies103915673doobies
doodies94218773doodies
doodle83212853doodle
doolee73018953doolee
doolies83920713doolies
doom76430073doom__
doomed104113293doomed
doomiest112910453doomiest
doomily1336133doomily
dooming113112533dooming
dooms85321343doom_s
doomy116018263doom_y
doozies173812723doozies
dormice1237133dormice
dormin9312313dormin
dowie94721143_dowie
doxie136017153_doxie
droolier936073droolier
droopier1145573droopier
duomi8310133duomi_
flooie93712153flooie
floosie10378933floosie
floozie19295463floozie
foamier12339003foamier
fogie96719003_fogie
folkie13369613folkie
fomite113314073_fomite
foodies113416753foodies
footier104115113footier
footies103721543footies
footle93914383footle
footsie1047653footsie
foozle18369203foozle
forme105225993form_e
formee113919943formee
formic13310453formic
gimmie11298183gimmie
gloomier1135093gloomier
gnome84213953gnom_e
gnomic11248593gnomic
goalie7413163goalie
goodies93516993goodies
goofier11339313goofier
gooier73516213goo_ier
goonier83612843goonier
goonies83618333goonies
goopier103910573goopier
goose65925903goo_se
goosier83512563goosier
gremmie1264383gremmie
groom85317983groom__
groomed11379503groomed
groomer10399873groomer
grooming12309513grooming
grooms94512523groom_s
groove10438873groo_ve
groovier1233793groovier
groupie1045783groupie
hoagie102310013hoagie
hogtie102711773hogtie
holmic1338783holmic
home98042443_hom_e
homier116416993_homier
homies114524723_homies
honkie133011673honkie
hoochie1537803hoochie
hoodier113812973hoodier
hoodies113419833hoodies
hookier143811673hookier
hookies144017443hookies
hoopoe11911233hoopoe
hootier104915353hootier
hottie92514383hottie
howdie13349733howdie
jimmie17376473jimmie
kookier10398283kookier
koppie14277883koppie
koumis1237623koumis
krooni10397183krooni_
loamier9349163loamier
loggie84011993loggie
loobies93814103loobies
looies65025833loo_ies
loom67035053loom__
loomed94616763loomed
looming102814853looming
looms75124643loom_s
loonier73312683loonier
loonies73919543loonies
loopier93711193loopier
loose56627683loo_se
louie55023513_louie
mamie95826003_mamie
mammie94313783mammie
moggie103210103moggie
mollie83517103mollie
mome85239353_mom_e
momi87524483_momi_
mommies103912273mommies
monie75631653_monie
moodier103212203moodier
moonier93714103moonier
moorier93113073moorier
moose76327193moo_se
movie105319133_movie
moxie144018123_moxie
nome66038423_nom_e
nomoi76012533nomoi_
noodge8337583noodge
noodle73212543noodle
noogies82814583noogies
nookies113414963nookies
noose55624063noo_se
ohmic1237833_ohmic
oldie6415473_oldie
omit65337373__omit
oolite63319603_oolite
oomiac1037063_oomiac
oomiak1235353_oomiak
oomph1236973_oomph
ootid61416703_ootid
ooze136420603_oo_ze
oozier153610253_oozier
oroide7311703oroide
osmic939913_osmic
ourie54027303_ourie
oxime1498433_oxime
pome85636693_pom_e
pommee122813283pommee
pommies133712843pommies
poodle93112043poodle
poori74816233poori_
pooris83916843pooris
poove104514303poo_ve
popsie103013053popsie
postie84123963postie
potpie103412433potpie
potsie83916033potsie
preemie11310563preemie
premie103617993premie
promine112819443promine
promise113415843promise
promote11313143promote
prossie91812953prossie
prostie91617743prostie
radome9511873radom_e
ramee74633853r_amee
rami66034093r_ami_
ramies84630463r_amies
rammier112811023rammier
ramose8314403ramose
reemit8717223reemit
regime95313943regime
remise84221953r_emise
remit75737223r_emit
remix145916553r_emix
remote84222603remote
remove116115573remove
reoil55321183reo_il
retie55735303r_etie
retime85321803retime
rheme106214053rhem_e
rhodic12227233rhodic
rhomb12399803rhom_b
rhombi13365203rhombi
rhombic16264533rhombic
rhombs13336493rhombs
rhotic112711233rhotic
rhyme13479553rhym_e
rime65138883r_im_e
rimier83916273r_imier
rimose8310593rimose
roadies83317443roadies
roam67132413roam__
roamed95215093roamed
roamer84715163roamer
roaming103215793roaming
roams74919613roam_s
robbin103611183robbin
robe65335643r_o_be
robin74820283r_obin
roble75223023r_oble
robotic1139223robotic
robotize1945693robotize
rockier134911883rockier
rode55844303r_o_de
rodlike1288263rodlike
rodman949713rodman
rodmen939713rodmen
roe36861083r_o__e
rogue66417533r_ogue
roil46235293r_o_il
roilier7311523roilier
rolamite1048743rolamite
role45851823r_o_le
rom59855633r_om__
romaine9512123romaine
roman75424823r_oman
romeo73719703r_omeo
romp85926573r_om_p
romped114513653r_omped
romper104213683r_omper
romps94617543r_omps
roms67038963r_om_s
rood56733003roo__d
roods65125283roo_ds
roof75738833roo__f
roofed105214743roofed
roofer94415283roofer
roofing113814353roofing
rooflike1534623rooflike
roofline1136193roofline
roofs85321153roo_fs
rook85532033roo__k
rooked114918143rooked
rookiest122912173rookiest
rooking123517363rooking
rooks95325043roo_ks
rooky126117623roo_ky
roomers95416413roomers
roomette1046103roomette
roomful1244183roomful
roominess1157303roominess
roommate1244863roommate
roosed75621593roosed
rooser63921883rooser
rooses65526233rooses
roosing84018133roosing
roost55730933roo_st
roosted83211883roosted
rooster74415173rooster
roosts64916323roosts
root45655923roo__t
rootage839053rootage
rooted75424003rooted
rooter64926033rooter
rootiest83115593rootiest
rooting83522433rooting
rootled83410533rootled
rootles73215633rootles
rootlet73015733rootlet
rootlike1236613rootlike
roots55933673roo_ts
rooty86423023roo_ty
rope65542913r_o_pe
ropier84118803r_opier
roque144812133r_oque
roscoe839763roscoe
rose46148903r_o_se
roshi8310753roshi_
roshis9311793roshis
rosier64221263r_osier
rosin55325313r_osin
rosolio746983rosolio
rotate63320343rotate
rotche114311983rotche
rote46249023r_o_te
roti46332933r_oti_
rotis56327063r_otis
rotte54625933r_otte
rouble83913313rouble
rouche114714313rouche
roue45941743r_o_ue
rouge65423443r_ouge
roupier9319493roupier
rouse56634703r_ouse
route55132073r_oute
routine72615903routine
rove75136983r_o_ve
rowdier11348593rowdier
rowdies113112693rowdies
rummier11309563rummier
rummies113212793rummies
sodomies11128553sodomies
sodomite11136913sodomite
sodomize20135253sodomize
softie93312483softie
some66040383_som_e
somite84519373_somite
sonsie6614863sonsie
soothe94214853soothe
sootier73916613sootier
sortie63621993sortie
stogie7311323stogie
stoolie739723stoolie
stymie1137623stymie
tammie104212693tammie
tome67543193_tom_e
tommies113812983tommies
toom66532933toom__
toonies73719883toonies
tootle62613813tootle
tootsie737133tootsie
towie85821873_towie
townie93312303townie
trompe105611263trompe
twoonie1034423twoonie
vogie95116663_vogie
vomit102622573_vomit
vroom105312473vroom__
vroomed13366433vroomed
vrooming14287353vrooming
vrooms11398713vroom_s
whoopie15295933whoopie
woodier113912063woodier
woodies113517153woodies
woolier103612353woolier
woolies104117363woolies
woozier19347323woozier
wormier12278763wormier
wormil1138043wormil
yomim12510083_yomim
yowie114616453_yowie
zombie1937323zombie
zooid15312103zoo_id
zooier153411233zoo_ier
zoom156722103zoom__
zoomed183610363zoomed
zooming19269653zooming
zooms164415523zoom_s
zootier163611173zootier
zowie174313843_zowie

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 Filter1786911127160.373479064.3
2DLD Change Limit1127164725.37620966.5
3Display Results4724720.1533085.0
 (SQL Overall)1786914725.90230276.3
 
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.