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

101 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
icecap124522(None) 
icecaps1343861icecaps
becap114315052_becap
ceca84820782_ceca_
cecal94619112_cecal
iceman1037852iceman
ipecac1264622ipecac
recap95718022_recap
toecap1037322toecap
aceta74017353aceta_
acetal84314903acetal
areca75618633areca_
arecas84817443arecas
becaps123811403_becaps
bicep115413543bice__p
bluecap1343113bluecap
caca85528083_caca_
cacao95420003_cacao
cacas95627983_cacas
caeca93915133caeca_
caecal103713733caecal
cap76758983___cap
cecum11611843_cecum
cedar84014323_cedar
cep75736333_ce__p
cercal10314123_cercal
chap114928493_c_hap
cheap126915943_cheap
circa9311403circa_
clap86429043_c_lap
coca88030643_coca_
cocas95926573_cocas
crap85731843_c_rap
cycad13507273_cycad
cycas126513823_cycas
decaf114919443_decaf
decal85523233_decal
decamp1338453_decamp
decay114718483_decay
eyecup1344493eyecup
faecal11359813faecal
fecal105119213_fecal
gelcap1136213gelcap
heap96432893_he_ap
hiccup1554393hic_cup
hubcap1553993hubcap
ice56737243ice___
iceboat1147163iceboat
icebox1753083icebox
icecapped1841433icecapped
iced78721893ice__d
icefall1254303icefall
icemen1037893icemen
ices66129643ice__s
icicle1036583icicle
idea59122773ide_a_
ideal65716393ide_al
ideas65919013ide_as
ilea45931463ile_a_
ileac75814173ile_ac
ileal56118083ile_al
inscape1138023inscape
inwrap11115903inwrap
ipecacs1354503ipecacs
kneecap1542303kneecap
leap66032683_le_ap
madcap1336333madcap
mecca1139933mecca_
meccas1239493meccas
microcap1645583microcap
midcap1336473midcap
mobcap1444113mobcap
mudcap1335133mudcap
neap66927013_ne_ap
ocean71212963oce_an
ocicat101412813ocicat
pecan91919033_pecan
pinesap1164723pinesap
reap65934743_re_ap
recaps103615733_recaps
redcap1158493redcap
remap95418103_remap
ricercar1263333ricercar
scena74815783scena_
scenas84114703scenas
scrap97120403sc_rap
siccan1037593sic_can
sidecar1045233sidecar
skycap1742913skycap
sneap75514823sne_ap
theca103311453theca_
thecae11299653thecae
thecal113310303thecal
toecaps1135553toecaps
uncap9312283_uncap
whitecap1842713whitecap
wicca1247253wic_ca_
wiccan1335033wic_can
wiccas1336543wic_cas
winesap1264443winesap
wiretap12145723wiretap

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161014.69024033.3
3Display Results1011010.0303366.7
 (SQL Overall)1786911015.09335085.6
 
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.