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

230 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
kaliph153787(None) 
caliph13311401caliph
kaliphs1634291kaliphs
aleph10311392_aleph
caliphs1436752caliphs
kalian10312162kalian
kalif125021362kali_f
kalifs134410982kalifs
kalium1239472kalium
kalpa114512192kal_pa
kaph135815752ka__ph
palish114718272palish
ralph1078742ral_ph
aalii5316133aali_i
aaliis6312903aaliis
acaleph1453443acaleph
alephs1136533_alephs
alias55834603_alias
alibi7514233_alibi
alien56425583_alien
alif76242143_ali_f
alifs86121263_alifs
alight103816863_alight
align65016503_align
alike95523963_alike
aline57243153_aline
aliped95414283_aliped
alist56136783_alist
alit46155693_ali_t
alive85722513_alive
aliya83713483_aliya
aliyah12397493_aliyah
almah106917253_almah
almeh106214553_almeh
alp56641133_al_p_
alpha1049653_al_pha
alps65529243_al_ps
apish105116633_apish
baith108023133ba_ith
baldish1339503baldish
baling94829693baling
banish111416043banish
blip88322773_blip_
blips95615783_blips
calash11312433calash
caliche14329963caliche
calico103414433calico
calif104929103cali_f
califs114915893califs
calipash1543233calipash
calipee11412913calipee
caliper11410963caliper
caliphal1544033caliphal
calix145317353cali_x
caph116623293ca__ph
carlish12312773carlish
ceriph1398463ceriph
clip86924003_clip_
clips96018303_clips
clipt96324273_clipt
daledh1133743daledh
daleth1038633daleth
danish101513793danish
delish105215613delish
eolith93013903eolith
faith115620853fa_ith
famish14311843famish
flip96324263_flip_
flips105117743_flips
galah95917643gal_ah
galiot72322593galiot
galipot1049543galipot
galop84716223galop_
galops94712623galops
galosh1038573galosh
galumph15102663galumph
garish104516923garish
glyph1456473_glyph
hadith13312063hadith
halid94424983hali_d
halide103417993halide
halids104016133halids
haling104229783haling
halite93624233halite
hallah124115403hallah
halvah15499833halvah
jadish17319903jadish
jalap143612473jalap_
jalaps15299183jalaps
jalop144212603jalop_
jalops15329593jalops
jalopy18325863jalopy
kabiki1134783kabiki
kaddish16317973kaddish
kadi96224833kadi__
kadis105921063kadi_s
kafir12488903kafi_r
kafirs13306983kafirs
kaiak8310353ka_iak
kaif116933933ka_i_f
kaifs125715643ka_ifs
kail85131493ka_i_l
kails95525213ka_ils
kain85334293ka_i_n
kains96125643ka_ins
kakapo1143853kakapo
kaki76520913kaki__
kakis86116843kaki_s
kalam11315113kal_am
kalams12310603kalams
kale86533753kal__e
kales95730983kal_es
kalians11310183kalians
kalimba1542663kalimba
kaliphate1843253kaliphate
kaliums1336603kaliums
kalmia1238893kalmia
kalmias1347973kalmias
kalong1177703kalong
kalpac14428223kalpac
kalpak11437243kalpak
kalpas124112943kalpas
kami105823643kami__
kamik105011553kami_k
kamiks11387913kamiks
kaolin1039583kaoli_n
kaoline11310143kaoline
kaolins1139363kaolins
kapa106021293ka__pa
kaphs144911503ka__phs
kappa13469743ka_ppa
kasbah1535183kasbah
kation104315683kation
kelep116014563kelep_
keleps12478813keleps
kelim11912553keli_m
kelims1278913kelims
kelp105322803kel_p_
kelpie12308613kelpie
kelps115116423kel_ps
kelpy145110683kel_py
khalif1657833khali_f
khalifa1742883khalifa
khalifs1754073khalifs
khaph17395963k_haph
kilim11711893kili_m
kilims1277903kilims
kip97042143k__ip_
kips106430523k__ips
kith115826363k__ith
klatch15445933klatch
klepht1535043k_lepht
klick105311433k_lick
klik74412653k_li_k
kliks8398823k_liks
knavish1743993knavish
knish1238603k_nish
koph135816543k__oph
kylix19416323kyli_x
laich105920713la_ich
laigh95515923la_igh
laith85722103la_ith
latish92416173latish
lavish124112983lavish
lich96230843__lich
lip514755803__lip_
lipa68425923__lipa
lipe66839733__lipe
lips67141443__lips
malic94525663mali_c
malice104818483malice
malign939853malign
maline84529083maline
marish114319053marish
mulish11311903mulish
oafish121311723oafish
oolith93813243oolith
owlish1238703owlish
oxlip1456883oxlip_
oxlips1544433oxlips
palapa10310673palapa
palier85023563palier
paling93530133paling
palp85828573pal_p_
palpi95414553pal_pi
palps94719563pal_ps
paraph13311263paraph
pariah114320583pariah
parish115022353parish
polish114916723polish
radish103516913radish
rakish134313963rakish
ralphs1135373ral_phs
ravish123414033ravish
rawish123012913rawish
relish93916953relish
saith85826553sa_ith
salep77022953salep_
saleps85014903saleps
salic73424713sali_c
salify12311373salify
salina64221123salina
saline65132703saline
saliva93110743saliva
salp64534093sal_p_
salpa75018353sal_pa
salpid9510883salpid
salps74423243sal_ps
saltish10312163saltish
slip67031733_slip_
slipe75626133_slipe
slips76023723_slips
slipt76627483_slipt
sylph1347793syl_ph
tali46837163tali__
talion6317713talion
taliped1078203taliped
talipes9611603talipes
talipot949723talipot
tallish103313583tallish
tallith102913063tallith
tulip71111693tulip_
tulips8137253tulips
valid94618393vali_d
valine94623093valine
valise92917643valise
vanish121513213vanish
walies95324523walies
waling104525303waling
wallah124011993wallah

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 Filter1786911127160.390458182.1
2DLD Change Limit1127162305.54620323.8
3Display Results2302300.0763026.3
 (SQL Overall)1786912306.01229722.4
 
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.