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

317 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
crannies1031301(None) 
crannied1137891crannied
grannies9312611grannies
trannies8415011trannies
brandies11714562brandies
brannier10218932brannier
branniest11199382branniest
candies104125612c_andies
canines93724032c_anines
cannie83819362c_annie_
cannier94014162c_annier
canniest10313362c_anniest
carnies94123962c_arnies
chanties132615802chanties
cranches153114542cranches
cranes84330752cra_n_es
crankier14339162crankier
crankiest1538822crankiest
crankles143510152crankles
crannoges1244242crannoges
crannogs1143782crannogs
crappies142911152crappies
crazies183413852cra_zies
cronies9622502cr_onies
cyanines132710542cyanines
fannies103415642_fannies
grannie8310352grannie_
nannies73015202_nannies
randies84225662_randies
shannies113411252shannies
tyrannies1255532tyrannies
alanines8314803alanines
araneids947743araneids
bandies104124863_bandies
banties94324763_banties
baronies10315023baronies
beanies93821093bea_nies
bennies93917313_bennies
blennies1056933blennies
brainier102510233brainier
brainiest11209723brainiest
branches153613803branches
brandied1259113brandied
branned104311693brann_ed
branner94212373brann_er
branners104010923branners
branning112911093branning
brassies103613533brassies
braunites1146723braunites
brawnier13216723brawnier
brawniest14197103brawniest
braxies16711463bra_xies
brinies93317913br_inies
brionies10310543brionies
brownies13189613brownies
bryonies1336843bryonies
bunnies94415003_bunnies
cabbies133115163c_abbies
caddies113718383c_addies
cammies134016483c_ammies
canapes111213083c_anapes
canaries10318943c_anaries
candids113812693c_andids
candied113816023c_andied
candles104422343c_andles
canes75350373c_a_n_es
cangues10611823c_angues
canids95118133c_a_nids
canine83826703c_anine_
canities101519263c_anities
cannas84518403c_ann_as
canned95022063c_ann_ed
cannel84216403c_ann_el
cannels93413363c_annels
canner84625983c_ann_er
canneries11313083c_anneries
canners93822663c_anners
cannily1239263c_annily
canniness1138643c_anniness
canning103620133c_anning
cannings113710333c_annings
cannons94412883c_annons
canoes84725883c_a_noes
canonise10511093c_anonise
canonises11410803c_anonises
canonizes2049593c_anonizes
canonries1148413c_anonries
canopies12311853c_anopies
cantles94721413c_antles
carabines13311463carabines
carangids1344573carangids
carbines123617533carbines
caries85147623c_a_ries
carlines103521643carlines
carmines123617863carmines
carnages11312213carnages
carnie84421093c_arnie_
carnifies1439893carnifies
carries94328013c_arries
catnips1195893c_atnips
catties94023053c_atties
cavies114525003c_a_vies
chaines124518733chain_es
challies133915643challies
chammies172910163chammies
chances145218093cha_nces
chancier1538823chancier
chanciest1638373chanciest
chancres15429363chancres
changes134517583cha_nges
channel123910483chann_el
channels13388493channels
chantries14310293chantries
chappies172610093chappies
charlies133414233charlies
clankier14327083clankier
clankiest1536663clankiest
clannish1345263clannish
claries93422203cla_ries
coannex1635513coann_ex
coannexes1843643coannexes
colonies103620013colonies
conies84338593c__onies
conines93827793c_onines
connives1339723c_onnives
coonties10513803coonties
corantoes1147653corantoes
counties10316283counties
crabbier14326803crabbier
crabbiest1535623crabbiest
crabwise1543613crabwise
crackles164111273crackles
cradles103114133cra_dles
craftier1376193craftier
craftiest1436913craftiest
craggier12116063craggier
craggiest13116523craggiest
crakes124921813cra__kes
crambes1339963cra_mbes
cramboes1436543cramboes
crampier14288903crampier
crampiest15268613crampiest
crampits1436273crampits
cranched163210413cranched
crane75331603cra_n_e_
craned96121653cra_n_ed
crania82418433cra_ni_a
cranial92114683cra_nial
craniates11310653craniates
craning103620303cra_ning
cranium11911103cra_nium
craniums1297913craniums
cranked143812843cra_nked
cranker133612783cra_nker
crankest1438143cra_nkest
crankily1755623crankily
crankiness1636173crankiness
cranking154613073cranking
crankish1736513crankish
crankle133610063crankle_
crankled15408153crankled
crankous1435973crankous
crankpins17133763crankpins
cranks125015313cra_n_ks
crannog1044243crann_og
crannoge1144263crannoge
cranny114210273crann__y
crapes104727693cra__pes
crappie13298983crappie_
crappier14288133crappier
crappiest15267263crappiest
crases85532313cra__ses
crashes124618403cra_shes
crasis85020473cra_si_s
cratches153012543cratches
crates85736063cra__tes
craunches1655723craunches
craves115825393cra__ves
cravings14428223cravings
crawlier13216873crawlier
crawliest14187403crawliest
crazes174720133cra__zes
crazier183610743cra_zier
craziest19319923cra_ziest
craziness2037383craziness
creatines112814433creatines
creepies1239613creepies
cries75438403cr___ies
cringes103215503cr_inges
cringles11329463cringles
crinites10612763crinites
crinkles14269163crinkles
crinoids1147363crinoids
crones84729243cr_on_es
croppies143111133croppies
crowdies1437553crowdies
crummies1437643crummies
crunches153711353crunches
crunodes1144973crunodes
cryonics1555413cryonics
curacies12311763cura_cies
curarines11710553curarines
cyanates13238433cyanates
cyanides14258003cyanides
cyanids13297933cya_nids
cyanine122911513cyanine_
cyanins122910013cya_nins
cyanites132610163cyanites
cyanoses1337423cyanoses
dandies94121443_dandies
errancies1147963errancies
fancies124018783_fancies
francizes2346793francizes
frenzies2037713frenzies
funnies104113603_funnies
gradines103615253gradines
grainier9218903grainier
grainiest10188993grainiest
granaries10159883granaries
grandees103211283grandees
granges93516523gra_nges
granites92116363granites
grantees92510973grantees
granules939933granules
gravies11314093gra_vies
greenies9312673greenies
guanines989773guanines
gunnies83413123_gunnies
hankies143617763_hankies
hinnies103615103_hinnies
ironies7517423ir_onies
jennies143511623_jennies
joannes1436243joann_es
johnnies1872993johnnies
mannites10312613_mannites
meanies93620743mea_nies
minnies93617363_minnies
nancies93516843_nancies
nannie63713223_nannie_
ninnies73713613_ninnies
oranges84215333ora_nges
orangier947713orangier
orangiest1038463orangiest
organdies1187213organdies
pandies104224503_pandies
pannes85522853_pann_es
pannier93613353_pannier
panniers10488853_panniers
pansies94521983_pansies
panties94230933_panties
pennies94218813_pennies
pinnies93318443_pinnies
prairies10411453prairies
pralines102217723pralines
prances113618773pra_nces
rabbies113416053_rabbies
rabies85226023_ra_bies
raggies93214733_raggies
rainier71614263_rainier
rainiest81214923_rainiest
rallies73823343_rallies
ramies84630463_ra_mies
rances84625443_ra_nces
ranches123620113_ranches
randier83618473_randier
randiest93418773_randiest
ranees64623963_ra_nees
ranges73826923_ra_nges
rangier83714353_rangier
rangiest93115983_rangiest
ranids75118703_ra_nids
ranis55235833_ra_ni_s
rankles113114543_rankles
ranpikes1435643_ranpikes
rapines95120863_rapines
ratanies8312923_ratanies
ratines75328583_ratines
ravines104220233_ravines
rennins74013413_rennins
runnier74010113_runnier
runniest82911203_runniest
sanies63031953_sa_nies
scanties103215423scanties
scrannel1044033scrann_el
scrannels1143513scrannels
scrapies124612473scra_pies
scrawnier1443643scrawnier
scrawniest1543483scrawniest
shandies122714103shandies
shanties113116583shanties
shinnies113010913shinnies
sonnies7315223_sonnies
spinnies103210543spinnies
stanines85115673stanines
stannites947023stannites
tannins72813223_tannins
tansies74521243_tansies
tawnies102812503_tawnies
tennies73017973_tennies
trainees82712063trainees
trances93919643tra_nces
tranches132915513tranches
transits8313503transits
trendies9312213trendies
truancies1146883truancies
tunnies73614263_tunnies
twankies1535893twankies
tyrannise1253713tyrannise
tyrannises1383973tyrannises
tyrannizes2263473tyrannizes
uranias72113813ura_nias
uranides92211283uranides
uraninites1045623uraninites
uranites82514643uranites
whinnies14237273whinnies
wrangles1237463wrangles
zanies153219673_za_nies

Search took 9 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 Limit1461623178.00018270.3
3Display Results3173170.1262515.9
 (SQL Overall)1786913178.54920902.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.