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

248 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
crawlier1321687(None) 
brawlier13267041brawlier
crawler123510461crawl_er
drawlier12225251drawlier
scrawlier1443901scrawlier
brawler124310232brawl_er
brawlie12198152brawlie_
brawnier13216722brawnier
coalier93416182coa_lier
crabbier14326802crabbier
cracklier1744822cracklier
cradler102910512cradl_er
craftier1376192craftier
craggier12116062craggier
crampier14288902crampier
crankier14339162crankier
crappier14288132crappier
crawled133710402crawl_ed
crawlers13309012crawl_ers
crawliest14187402crawliest
crawling143110512crawling
crazier183610742cra_zier
drawler11338592drawl_er
growlier1234882growlier
rallier73816272_rallier
scrawler1345892scrawl_er
scrawnier1443642scrawnier
sprawlier1443292sprawlier
trawler104011902trawl_er
bawdier13378203_bawdier
bawler114315053_bawl_er
braggier12136453braggier
brailler1036883brailler
brainier102510233brainier
brakier133812363bra_kier
bramblier1543503bramblier
brannier10218933brannier
brashier13389933brashier
brasier94516753bra_sier
brassier103310533brassier
brattier1047663brattier
brawer114216333braw__er
brawled133910123brawl_ed
brawlers13408643brawl_ers
brawliest14177193brawliest
brawling143210043brawling
brazier183911473bra_zier
brownier13226913brownier
cabler104519173c_abl_er
cagier93715933c_a_gier
cahier113615773c_a_hier
cakier123115243c_a_kier
caliber1139733c_a_liber
caliper11410963c_a_liper
calker124917083c_a_lker
caller85125483c_a_ller
calliper1247513c_alliper
calmer105216933c_a_lmer
campier133313273c_ampier
cannier94014163c_annier
caroler93816753carol_er
caroller1039203caroller
carrier93619583c_arrier
cashier123713323c_ashier
cattier93317073c_attier
caulker13456893c_aulker
cavalier1348183cavalier
caviler1249063c_aviler
chaffier1935473chaffier
chalkier1736753chalkier
challie124012853challie_
challies133915643challies
chancier1538823chancier
charier124317903cha_rier
charlie123011923charlie_
charlies133414233charlies
charrier1378683charrier
chattier1337513chattier
chawer144314413chaw__er
chewier1537593chew_ier
chillier13328423chillier
clammier1435843clammier
clankier14327083clankier
classier10359083classier
clavier1239173cla_vier
clawer114512783claw__er
clawlike1733913clawlike
clayier1248323cla_yier
cleanlier1143363cleanlier
coaler84121713coa_l_er
collier93618153c_ollier
comelier12310653comelier
complier14310253complier
costlier1038523costlier
cowier113616163c_ow_ier
craaled10339423craal_ed
craaling112711353craaling
crabber133810733cra_bber
crablike1636023crablike
cracker153114173cra_cker
cradle93313163cradl_e_
cradled113410813cradl_ed
cradlers11309203cradl_ers
cradles103114133cradl_es
cradling122411453cradling
crafter124111333cra_fter
crammer134010963cra_mmer
cranker133612793cra_nker
crannied1137893crannied
crannies10313013crannies
crapper133913193cra_pper
crappie13298983crappie_
crappies142911153crappies
crasher124616163cra_sher
crasser94114343cra_sser
crater85026643cra__ter
craver114618473cra__ver
crawfish1944233crawfish
crawl104916713crawl___
crawls114712083crawl__s
crawlway1941993crawlway
crawly144610763crawl__y
crayoner1344863crayoner
crazies183413853cra_zies
creakier14328333creakier
creamier12319063creamier
creasier103210193creasier
creepier1236253creepier
crepier1139743cr_epier
crier74724463cr___ier
crimpier14287323crimpier
crinklier1543843crinklier
crispier12297253crispier
croakier14436263croakier
crosier94116573cr_osier
croupier1246883croupier
crowder13389863crow_der
crowdie1335913crowdie_
crowdies1437553crowdies
crower114117563crow__er
crowner124012603crow_ner
crozier18369933cr_ozier
cruddier1244153cruddier
crueler939023cruel_er
crueller1056453crueller
cruller968753cr_uller
crumbier1456363crumbier
crumblier1543873crumblier
crummier1435603crummier
crumplier1543783crumplier
crustier10259533crustier
cuddlier1234013cuddlier
curlier93314183c_urlier
dallier84215373_dallier
darklier1335013darklier
deadlier1036863deadlier
draffier1574323draffier
draftier1285263draftier
draggier11135773draggier
drawer104711363draw__er
drawled12368343drawl_ed
drawlers12307313drawl_ers
drawliest13166243drawliest
drawling13318673drawling
droolier936073droolier
drowsier1284903drowsier
drumlier1134523drumlier
earlier72612743_earlier
fawnier13296363_fawnier
featlier1136453featlier
flawier13378733flaw_ier
frailer10319943frail_er
frillier1136513frillier
frowsier1444893frowsier
frowzier2343313frowzier
gawkier15326523_gawkier
gladlier1034343gladlier
gnarlier9255163gnarlier
grabbier13316653grabbier
grainier9218903grainier
grapier103712603gra_pier
grassier9349283grassier
grazier173611133gra_zier
grislier935793grislier
growler11318973growl_er
haulier1059943_haulier
jowlier17327563_jowlier
lowlier10338903_lowlier
manlier92414023_manlier
marblier1256343marblier
marlier92614773_marlier
mealier93015903mea_lier
measlier1036013measlier
nearlier836793nearlier
orangier947713orangier
palier85023563_pa_lier
pallier94417163_pallier
pawkier16236613_pawkier
pearlier1037323pearlier
prawner1246803praw_ner
prowler123310013prowl_er
racier85120973_ra_cier
railer64524933_rail_er
rainier71614263_rainier
rallied83514083_rallied
ralliers84010833_ralliers
rallies73823343_rallies
rammier112811023_rammier
randier83618473_randier
rangier83714353_rangier
rapier84019993_ra_pier
raspier93110643_raspier
rattier74015593_rattier
rawer84623733_raw__er
relier65826183_r_elier
replier94214973_replier
roilier7311523_roilier
rowdier11348593_rowdier
rulier65016353_r_ulier
sallier73320423_sallier
scalier94316913sca_lier
scrabblier1642773scrabblier
scraggier1344133scraggier
scragglier1442283scragglier
scrappier1544423scrappier
scrawled1445923scrawl_ed
scrawlers1434753scrawl_ers
scrawliest1553813scrawliest
scrawling15195583scrawling
screwier1346433screw_ier
shalier103116423sha_lier
snarlier8278183snarlier
sprawler1334653sprawl_er
strawier1137493straw_ier
tallier72817213_tallier
tawnier10318463_tawnier
trailer73015393trail_er
trampier12318243trampier
trashier113210103trashier
trawled113411523trawl_ed
trawlers113310203trawl_ers
trawley13317303trawl_ey
trawling122710783trawling
trawlnet1146583trawlnet
treaclier1144153treaclier
vealier102712173vea_lier
weaklier1534263weaklier
wrathier1435903wrathier

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.436409841.7
2DLD Change Limit1461622487.42319690.4
3Display Results2482480.0932666.7
 (SQL Overall)1786912487.95222471.2
 
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.