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

253 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
crabbier1432680(None) 
crabber133810731crabb_er
grabbier13316651grabbier
brabbler11397372brabbler
cabbie122913352c_abbie_
cabbies133115162c_abbies
chubbier1733892chubbier
clabber134210112clabb_er
clubbier1434832clubbier
cobbier133410162c_obbier
crabbed14388872crabb_ed
crabbers14358752crabb_ers
crabbiest1535622crabbiest
crabbily1744342crabbily
crabbing15287932crabbing
craftier1376192craftier
craggier12116062craggier
crampier14288902crampier
crankier14339162crankier
crappier14288132crappier
crawlier13216872crawlier
crazier183610742cra_zier
cribber13367662cribb_er
crumbier1456362crumbier
drabber12438592drabb_er
flabbier1534092flabbier
gabbier12379632_gabbier
grabber12389762grabb_er
grabbler13377692grabbler
grubbier13344752grubbier
rabbies113416052_rabbies
rabbiter1234672_rabbiter
rabbler113514092_rabbler
ribbier1137592_ribbier
scabbier1435132scabbier
scrabbler15195202scrabbler
scrabblier1642772scrabblier
scrubbier1543332scrubbier
shabbier1535182shabbier
babbler104012823_babbler
babier103515573_ba_bier
blabber10418923blabb_er
brabble10349973brabble_
brabbled12337633brabbled
brabblers12335563brabblers
brabbles11349753brabbles
braggier12136453braggier
brainier102510233brainier
brakier133812363bra_kier
bramblier1543503bramblier
brannier10218933brannier
brashier13389933brashier
brasier94516753bra_sier
brassier103310533brassier
brattier1047663brattier
brawlier13267043brawlier
brawnier13216723brawnier
brazier183911473bra_zier
cabbed135416263c_abb_ed
cabbing143613153c_abbing
caber95126833c_a_b_er
cabler104519173c_a_bler
cagier93715933c_a_gier
cahier113615773c_a_hier
cakier123115243c_a_kier
caliber1139733c_aliber
camber124418483c_amb_er
campier133313273c_ampier
cannier94014163c_annier
carabiner1346343carabiner
carabinier1444013carabinier
carrier93619583c_arrier
cashier123713323c_ashier
catbrier1236173catbrier
cattier93317073c_attier
chaffier1935473chaffier
chalkier1736753chalkier
chamber164011063chamb_er
chancier1538823chancier
charier124317903cha_rier
charrier1378683charrier
chattier1337513chattier
clabbers14359903clabb_ers
clamber133311743clamb_er
clammier1435843clammier
clankier14327083clankier
classier10359083classier
clavier1239173cla_vier
clayier1248323cla_yier
clobber13378163clobb_er
clubber13319593clubb_er
coalier93416183coa_lier
cobber124116843c_obb_er
cobbler133311823c_obbler
crabby15346753crabb__y
crabeater1345593crabeater
crablike1636023crablike
crabwise1543613crabwise
cracker153114173cra_cker
cracklier1744823cracklier
cradler102910513cra_dler
crafter124111333cra_fter
crambe1239073cramb_e_
crambes1339963cramb_es
cramboes1436543cramboes
crammer134010963cra_mmer
cranker133612793cra_nker
crannied1137893crannied
crannies10313013crannies
crapper133913193cra_pper
crappie13298983crappie_
crappies142911163crappies
crasher124616163cra_sher
crasser94114343cra_sser
crater85026643cra__ter
craver114618473cra__ver
crawler123510463cra_wler
crayoner1344863crayoner
crazies183413853cra_zies
creakier14328333creakier
creamier12319063creamier
creasier103210193creasier
creepier1236253creepier
crepier1139743cr_epier
cribbed14407663cribb_ed
cribbers14306443cribb_ers
cribbing15276843cribbing
cribbled15305803cribbled
crier74724463cr___ier
crimpier14287323crimpier
crispier12297253crispier
croakier14436263croakier
crosier94116573cr_osier
croupier1246883croupier
crozier18369933cr_ozier
cruddier1244153cruddier
crumber13339643crumb_er
crumblier1543873crumblier
crummier1435603crummier
crustier10259533crustier
crybabies1842723crybabies
cubbies133312883c_ubbies
dabber114816963_dabb_er
dabbler124012153_dabbler
daubier1037103_daubier
drabbed13428723drabb_ed
drabbet12319573drabb_et
drabbing14286803drabbing
drabble12238883drabble_
drabbled14367053drabbled
drabbles13308523drabbles
draffier1574323draffier
draftier1285263draftier
draggier11135773draggier
drawlier12225253drawlier
dribbler13316313dribbler
drubber12357863drubb_er
fabber134814113_fabb_er
fribbler15265953fribbler
gabber114916603_gabb_er
gabbler124013303_gabbler
gambier124711973_gambier
globbier1334243globbier
grabbed13368643grabb_ed
grabbers13337883grabb_ers
grabbiest1435323grabbiest
grabbing14267313grabbing
grabble12339643grabble_
grabbled14327373grabbled
grabblers14345513grabblers
grabbles13339893grabbles
grainier9218903grainier
grapier103712603gra_pier
grassier9349283grassier
grazier173611133gra_zier
grubber12417913grubb_er
jabber173713643_jabb_er
knobbier1652703knobbier
knubbier1642513knubbier
lambier113611643_lambier
marblier1256343marblier
nabber104913543_nabb_er
nobbier11309163_nobbier
nubbier11308133_nubbier
orangier947713orangier
orbier839993or__bier
rabbet103818653_rabb_et
rabbi93113183_rabbi__
rabbin103112303_rabbi_n
rabbins112811343_rabbins
rabbis102613163_rabbi_s
rabbit102914563_rabbi_t
rabbited1334763_rabbited
rabbiters1343733_rabbiters
rabbitry15243383_rabbitry
rabbits11299863_rabbits
rabbity14266303_rabbity
rabble103818243_rabble_
rabbled123514423_rabbled
rabblers123810853_rabblers
rabbles113517973_rabbles
rabies85226023_ra_bies
racier85120973_ra_cier
rainier71614263_rainier
rallier73816273_rallier
rambler113313263_rambler
rammier112811023_rammier
randier83618473_randier
rangier83714353_rangier
rapier84019993_ra_pier
raspier93110643_raspier
rattier74015593_rattier
ribber103515493_ribb_er
ribier84414233_r_ibier
robber103916533_robb_er
rubber104715793_rubb_er
rubbies114114113_rubbies
rubblier1244913_rubblier
rubier84814743_r_ubier
scrabble14196993scrabble_
scrabbled16154973scrabbled
scrabblers16213813scrabblers
scrabbles15206283scrabbles
scraggier1344133scraggier
scrambler15165043scrambler
scrappier1544433scrappier
scrawlier1443903scrawlier
scrawnier1443643scrawnier
scribbler15164223scribbler
scrubber1434123scrubb_er
shrubbier1642193shrubbier
slabber113311393slabb_er
slobbier1254633slobbier
snobbier1234633snobbier
snubbier1244993snubbier
squabbier2242753squabbier
stabber113610153stabb_er
stubbier1235353stubbier
swabber14297963swabb_er
swabbie1484333swabbie_
swabbies15115713swabbies
tabbied12297793_tabbied
tabbies112913503_tabbies
trampier12318243trampier
trashier113210103trashier
tubbier11237743_tubbier
wabbler143511923_wabbler
wabblier15375493_wabblier
webbier1445423_webbier
wrathier1435903wrathier
yabber136111833_yabb_er
yabbie13308663_yabbie_
yabbies14279643_yabbies

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 Limit1461622537.40619735.6
3Display Results2532530.0932720.4
 (SQL Overall)1786912537.92222556.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.