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

229 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
frillier113651(None) 
friller104111741frill_er
chillier13328422chillier
driller84311882drill_er
filler94623622f_ill_er
fillies103420252f_illies
filmier1237502f_ilmier
frilled113911602frill_ed
frillers11349872frill_ers
frilliest1237112frilliest
frilling123011492frilling
fringier1236552fringier
friskier1535192friskier
frizzier19284812frizzier
frizzlier20122882frizzlier
griller84513352grill_er
grislier935792grislier
hillier103413962_hillier
millier93716702_millier
rallier73816272_rallier
sillier74017592_sillier
stillier868822stillier
triller74215892trill_er
bilgier10358533_bilgier
biller84923483_bill_er
billie85019173_billie_
billies93923503_billies
brailler1036883braill_er
brawlier13267043brawlier
brickier16307163brickier
bridler103811073bridl_er
brinier93613473bri_nier
bristlier1144313bristlier
brollies1039533brollies
bullier94116433_bullier
childlier1543093childlier
chiller124112183chill_er
chillies134113483chillies
collier93618153_collier
crawlier13216873crawlier
crimpier14287323crimpier
crinklier1543843crinklier
crispier12297253crispier
cruller968753crull_er
dallier84215373_dallier
dillies84122163_dillies
drawlier12225253drawlier
driftier1275123driftier
drilled94711673drill_ed
drillers9429723drill_ers
drilling103311983drilling
drippier1385043drippier
drizzlier18122303drizzlier
droller84110283droll_er
droolier936073droolier
drumlier1134523drumlier
eviller1056673evill_er
faille93414743faill_e_
failles102914133faill_es
faller94621233f_all_er
faultier1135283faultier
featlier1136453featlier
feistier1136193feistier
feller94419553f_ell_er
fellies104119743f_ellies
fielder11217413f_ielder
fierier103511193f_ierier
filcher15377793f_ilcher
filer85433003f_i_l_er
fille84327403f_ill_e_
filled104922263f_ill_ed
fillers104320213f_ill_ers
filles94224523f_ill_es
fillet95027083f_ill_et
filling113520803f_illing
fillip11268953f_illi_p
filliped1435223f_illiped
fillips12298133f_illips
fillister1244423f_illister
filmer114112403f_i_lmer
filter94517633f_i_lter
filthier1434073f_ilthier
finnier10319953f_innier
firrier103410133f_irrier
fishier13359853f_ishier
fizzier18326713f_izzier
flier86023403f___lier
flimsier1344133flimsier
flintier1136393flintier
flirtier1144893flirtier
folkier14359043f_olkier
follies103618943f_ollies
frailer10319943frail_er
frailties1245853frailties
freakier15246483freakier
frecklier1842993frecklier
frettier1156593frettier
friaries11310083friaries
fribbler15265953fribbler
friendlier1441823friendlier
frier85225843fr___ier
frill84917563frill___
frillings13265803frillings
frills94414223frill__s
frilly124111443frill__y
frisker14389273fri_sker
fritter103912773fri_tter
frivoler1443933frivoler
frivoller1542433frivoller
frizer184011283fri__zer
frizzer18446893fri_zzer
frizzies19315933frizzies
frizzler19345843frizzler
froggier1354643froggier
frontier1147313frontier
frostier1148163frostier
frothier1435953frothier
frouzier2043703frouzier
frowsier1444893frowsier
frowzier2343313frowzier
fruitier1136593fruitier
frumpier1534173frumpier
fueller10279963fuell_er
fuller94220383f_ull_er
fusilier1135423fusilier
gainlier965673gainlier
ghillie11326353ghillie_
ghillies12408663ghillies
giller74519733_gill_er
gillie74816943_gillie_
gillied95512313_gillied
gillies84120963_gillies
girlier8289523_girlier
grille74315743grill_e_
grilled94012833grill_ed
grillers93810813grill_ers
grillery12355503grill_ery
grilles83715023grill_es
grilling103811533grilling
grimier103210433gri_mier
gripier103210323gri_pier
grippier1355203grippier
gristlier1044283gristlier
grittier9316263grittier
grizzlier18112453grizzlier
growlier1234883growlier
guiltier934493guiltier
hiller94421633_hill_er
iller54821293__ill_er
inlier63615363__inlier
jollier142911003_jollier
killer104917953_kill_er
killie104114893_killie_
killies113318113_killies
kruller1145153krull_er
milkier133411163_milkier
miller84625413_mill_er
milliers102611903_milliers
milliner102811863_milliner
miltier93214963_miltier
oilier64417233_oi_lier
pallier94417163_pallier
pricier113313113pri_cier
prickier16368143prickier
pricklier17245063pricklier
prilled104713003prill_ed
prilling113413413prilling
prissier10157873prissier
privier122910453pri_vier
rallied83514083_rallied
ralliers84010833_ralliers
rallies73823343_rallies
relier65826183_r_elier
replier94214973_replier
ribbier1137593_ribbier
ribier84414233_ri_bier
ridgier937883_ridgier
rifler94014263_rifl_er
rille55728733_rill_e_
rilled74525653_rill_ed
rilles64725503_rill_es
rillet64828853_rill_et
rilling84023623_rilling
rimier83916273_ri_mier
ripplier1234463_ripplier
riskier1138423_riskier
ritzier16297203_ritzier
roilier7311523_roilier
roller63919793_roll_er
rulier65016353_r_ulier
sallier73320423_sallier
shellier1138393shellier
shriller1136823shrill_er
silkier114411643_silkier
siller64026063_sill_er
sillies73425083_sillies
siltier73413863_siltier
smellier1036793smellier
spiller92914333spill_er
stiller73414303still_er
swiller103211663swill_er
swirlier1135213swirlier
tallier72817213_tallier
thriller1165553thrill_er
tiller64222543_till_er
trickier143010233trickier
tricklier15256823tricklier
trifler103912153trifl_er
trilbies1037693trilbies
trilled84116313trill_ed
trillers83613493trill_ers
trilling92815963trilling
trillion847973trillion
trillium1046203trillium
trippier1246623trippier
troller73913173troll_er
trollied935893trollied
trollies8310233trollies
twirlier1133513twirlier
whirlier14175293whirlier
wilier93217073_wi_lier
willer94021063_will_er
willie94116453_willie_
willied114611563_willied
willies103920153_willies
woollier1155433woollier
wrigglier1462413wrigglier
wrinklier1643013wrinklier
wristier1136863wristier

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 Limit1461622296.90621164.5
3Display Results2292290.0932462.4
 (SQL Overall)1786912297.42224075.9
 
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.