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

255 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
caliphs143675(None) 
caliph13311401caliph_
kaliphs1634291kaliphs
acalephs1542992acalephs
alephs1136532_alephs
calices114321692calices
caliche14329952caliche
caliches153812262caliches
calicos113913492calicos
califs114915892cali_fs
calipash1543222calipash
calipee11412912calipee
calipees1247412calipees
caliper11410962caliper
calipers1249442calipers
caliphal1544032caliphal
caphs124515372ca__phs
ceriphs1484752ceriphs
clips96018302c_lip_s
kaliph1537872kaliph_
ralphs1135372ral_phs
talipes9611602talipes
aaliis6312903aali_is
acaleph1453443acaleph_
acalephe1552733acalephe
acalephes1643223acalephes
aleph10311393_aleph_
alias55834603_ali_as
alibis8311073_alibis
aliens65619213_aliens
alifs86121263_ali_fs
alight103816863_alight
alights113211433_alights
aligns75312953_aligns
alines65735223_alines
aliped95414283_aliped
alipeds10386793_alipeds
aliyahs13395323_aliyahs
aliyas93911803_aliyas
aliyos9349533_aliyos
almahs118611613_almahs
almehs11619493_almehs
alpha1049653_al_pha
alphas1139513_al_phas
alps65529243_al_p_s
blips95615783_blip_s
cabins104418923cabi_ns
cadis84428503cadi__s
cahiers123510673cahiers
caids85226423ca_i_ds
cains75334303ca_i_ns
cairds96411513ca_irds
cairns85313303ca_irns
calamus1139243calamus
calash11312433calash_
calashes13310533calashes
calathi1247583calathi
calathos1347523calathos
calathus1345023calathus
calcars11312653calcars
calces104420053cal_ces
calcines12314753calcines
calcites12313003calcites
calciums1446163calciums
caleche14297943caleche
caleches15269933caleches
calends1039523calends
calesas9411833calesas
calfs104919383cal__fs
caliber1139733caliber
calibers1238523calibers
calibre1136603calibre
calibres1237103calibres
calicle113111433calicle
calicles123811433calicles
calico103414433cali_co
calicoes123911593calicoes
calif104929103cali__f
calipashes1742453calipashes
caliphate1645293caliphate
caliphates1745133caliphates
calix145317353cali__x
calkers134414693calkers
calkings15289223calkings
calkins133814873calkins
calks115421603cal__ks
callans94518473callans
callas84526753cal_las
callees94117783callees
callers94221963callers
callets93821703callets
callings113613833callings
calliopes1346143calliopes
callipee1237733callipee
callipees1345303callipees
calliper1247513calliper
callipers1356493callipers
callous93516603callous
calls75634733cal__ls
callus85317073cal_lus
calms95222353cal__ms
calos74431903cal__os
calpac123211063cal_pac
calpacs133110343calpacs
calques182710193calques
calves115119283cal_ves
calxes154113033cal_xes
calyces14428803calyces
calypso1443123calypso
calypsos1543113calypsos
calyxes19426233calyxes
camions113916133camions
camisas113411923camisas
camises114218463camises
campos125217953ca_mpos
camps116330263ca_mp_s
campus125213923ca_mpus
canapes111213083canapes
canids95118133cani_ds
canines93724033canines
capes95441923ca__pes
caph116623293ca__ph_
capias10318353capi_as
capizes20410373capizes
caplins113515993capli_ns
capos94826073ca__pos
caps87147893ca__p_s
caribes113715643caribes
carices114220953carices
caries85147623cari_es
carinas93622403carinas
carious93320283carious
caritas93316953caritas
carlines103521643carlines
carlings114015853carlings
carlins93921913carli_ns
carlish12312763carlish_
carps96932253ca_rp_s
carpus105514303ca_rpus
casbahs1436463casbahs
casings104013513casings
casinos93512833casinos
casitas93312043casitas
cations94524143cations
catlings113712043catlings
catlins93818843catli_ns
catnips1195893catnip_s
caulis85320083cauli__s
caviars1238623caviars
cavies114525003cavi_es
cavils114014393cavi_ls
cavings134712543cavings
ceilidhs1442133ceilidhs
celiacs11157893celiacs
ceriph1398463ceriph_
chalahs15289883chal_ahs
chalehs15268803chal_ehs
chalices15310813chalices
challahs16377563challahs
chalupas1554383chalupas
chips125721253c_hip_s
cilices113814023cilices
clachs133511323c_lachs
claims105211573clai_ms
clamps124515083clamp_s
claps95626183c_lap_s
clasps104512093clasp_s
clepes104214623c_lepes
cliche133712453c_liche
cliches144213743c_liches
clicks145315113c_licks
cliffs14477593c_liffs
clifts11519153c_lifts
climbs12498723c_limbs
climes104720003c_limes
clines84926043c_lines
clings95716213c_lings
clinks125815063c_links
clip86924003c_lip__
clipt96324273c_lip_t
clops95924853c_lop_s
cloths115512483c_loths
coalpits1245403coalpits
colics104219903coli_cs
colies84837053coli_es
colins85229043coli_ns
colitis92617353colitis
cripes105120873c_ripes
culices113713123culices
cylices14359283cylices
daledhs1232783daledhs
daleths1135323daleths
eoliths10318573eoliths
faiths124610273fa_iths
flips105117743_flip_s
galahs105512673gal_ahs
galiots82311323galiots
galipot1049543galipot
galipots1145213galipots
galops94712623galop_s
galumphs1642023galumphs
glyphs1534303_glyphs
hadiths1436023hadiths
halides113416663halides
halids104016133hali_ds
halites103221193halites
halitus10339963halitus
hallahs133912463hallahs
halvahs16417533halvahs
jalaps15299183jalap_s
jalops15329593jalop_s
kalians11310183kalians
kalifs134410983kali_fs
kaliums1336603kaliums
kalpas124112943kal_pas
kaphs144911503ka__phs
laichs115110893la_ichs
laighs10508803la_ighs
lips67141443__lip_s
malices114316623malices
maligns1038133maligns
malines93625603malines
ooliths10268323ooliths
oxlips1544433oxlip_s
palapas11311493palapas
palings103915823palings
palish114718273palish_
palps94719563pal_p_s
palpus104210283pal_pus
paraphs1439313paraphs
pariahs123812343pariahs
ralph1078743ral_ph_
saleps85014903salep_s
salinas73116093salinas
salines74029413salines
salivas10309603salivas
salpas85116923sal_pas
salpids1038193salpids
salps74423243sal_p_s
scalps104315233scal_p_s
scarphs14437413sca_rphs
slipes84921413_slipes
slips76023723_slip_s
sylphs1435543syl_phs
talions7314113talions
taliped1078203taliped
talipeds1183553talipeds
talipot949723talipot
talipots1045623talipots
talliths11377433talliths
tulips8137253tulip_s
valines104520213valines
valises103516263valises
walies95324523wali_es
wallahs13409473wallahs

Search took 7 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 Filter1786911340270.420425454.8
2DLD Change Limit1340272556.06322105.7
3Display Results2552550.0932741.9
 (SQL Overall)1786912556.57627173.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.