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 “crane” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

231 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
crane7533160(None) 
cane66653121c_ane
crake114823521crake
craned96121651craned
cranes84330751cranes
crank114819611crank
crape96128441crape
crate76537401crate
crave105626311crave
craze165221461craze
crone75231331crone
alane56135612alane
ane37866952__ane
arame75026622arame
arcane81216742arcane
arene55329412arene
bane65250432_bane
borane84620212borane
brace95629272brace
brae65639112bra_e
brake116025342brake
bran65740382bran_
brand85124492brand
brank115222282brank
brans75437432brans
brant74742172brant
brave104925502brave
braze165423452braze
brine75132272brine
cade76443912c_ade
cafe95230322c_afe
cage75339062c_age
cake105439962c_ake
came87648752c_ame
can57760142c_an_
caned85838092c_aned
caner75334772c_aner
canes75350372c_anes
canoe75627252c_anoe
cans65050852c_ans
cant66362032c_ant
cape87242782c_ape
carafe115416162carafe
carate84734002carate
care66968372c_are
carle74535702carle
carn66245432carn_
carnet84732872carnet
carney115315702carney
carnie84421092carnie
carns75937562carns
carny105822922carny
carse74934332carse
carte75940422carte
carve106227752carve
case65848082c_ase
cate66254602c_ate
cave95941262c_ave
cease75227652cease
cerate84829462cerate
cetane8315282cetane
chafe135117352chafe
chaine115119222chaine
chance134617092chance
chang115418562chang
change124116752change
chant105932692chant
chape125221142chape
chare105231982chare
chase105127122chase
chine105231722chine
cine66242942c_ine
clade85821012clade
clan65633922clan_
clang86019312clang
clank114719522clank
clans75031012clans
clave105420152clave
cline76428532cline
clone75728162clone
cone67256962c_one
craal74117752craal
crab85727672cra_b
crabs95421392crabs
crack134120532crack
cradle93313162cradle
craft105327662craft
crag75625302cra_g
crags85622572crags
crakes124921812crakes
cram85635492cra_m
crambe1239072crambe
cramp115120692cramp
crams96229152crams
cranch133613532cranch
crania82418432crania
cranked143812842cranked
cranker133612782cranker
crankle133610062crankle
cranks125015312cranks
cranky153910632cranky
cranny114210272cranny
crap85731842cra_p
craped116120522craped
crapes104727692crapes
craps95328642craps
crases85532312crases
crash109120012crash
crass76328042crass
crated94827772crated
crater85026642crater
crates85736062crates
craved125417772craved
craven114113932craven
craver114618462craver
craves115825392craves
craw97725262cra_w
crawl104916712crawl
craws105723122craws
crazed184714452crazed
crazes174720132crazes
crazy195511222crazy
crease85519572crease
create85126372create
creme94319322creme
crenel84213062crenel
crepe95520722crepe
crime94822692crime
cringe93515482cringe
cripe95521142cripe
crones84729242crones
crony105918672crony
crore74922862crore
croze164719452croze
crude86018572crude
cruse75726102cruse
curare84916952curare
curate85226242curate
cyan96419622cyan_
cyano105512492cyano
cyans105714812cyans
drake104918302drake
drank104816202drank
drape85319632drape
drave95219272drave
drone65324982drone
erase54925492erase
erne46727422er_ne
fane75343572_fane
frae75330472fra_e
frame105821802frame
franc104615412franc
frank124417512frank
furane94015492furane
gane55145302_gane
grace85124542grace
grade75126092grade
gran56335012gran_
grana65722092grana
grand75122692grand
grange83716202grange
grans64832542grans
grant64840022grant
grape84824662grape
grate64932882grate
grave94624872grave
graze155820052graze
inane52820342inane
irade65618152irade
irate55627982irate
irone55126362irone
jane115031482_jane
kane85133972_kane
krone94018732krone
lane45153332_lane
liane54720662liane
mane65052032_mane
octane81411632octane
orang65119942orang
orange74016322orange
orate55133302orate
pane64950292_pane
plane74929142plane
prance104318572prance
prang84820322prang
prank115019452prank
prase76128752prase
prate75135982prate
prone75332622prone
prune75119632prune
race66746262_race
rage55742352_rage
rake84841572_rake
rale45050562_rale
ran38266622_ran_
rance75028512_rance
rand55839572_rand
ranee55438102_ranee
rang56939162_rang
range64728412_range
rani46640112_rani
rank85135532_rank
rant45864682_rant
rape65041632_rape
rare45348432_rare
rase46149982_rase
rate45458762_rate
rave75542092_rave
raze135235432_raze
rune45236292_rune
sane45954342_sane
scrape105917572scrape
stane55933002stane
thane86122532thane
trace75829612trace
trade65026042trade
trance84718762trance
trank96222422trank
tranq145416892tranq
trans54933042trans
trave85223032trave
trine54734602trine
trone55131862trone
urare56322552urare
urase54624682urase
urate55432162urate
urbane82211382urbane
urine55026592urine
vane75534692_vane
wane76344722_wane
wrang94716112wrang

Search took 2 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 Filter178691538000.0961861364.6
2DLD Change Limit538002311.59333772.8
3Display Results2312310.0603850.0
 (SQL Overall)1786912311.749102167.5
 
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.