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

152 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
ischia113639(None) 
ischial1246421ischial
chia96026622__chia
ischemia1544072ischemia
ischium1444242ischium
lochia1158312lochia
schwa13426842_schwa
aecia73819283aec_ia
archil11611573archil
asci66519143asc_i_
ascidia1046683ascidia
asthma11126563asthma
biochip1645323biochip
biscuit1147373biscuit
boccia12338793boccia
brachia141910423brachia
chai95929903__chai
chi86228653__chi_
chiao105618363__chiao
chias104625523__chias
chic115925203__chic
chica125818263__chica
chid106626403__chid
chin96934743__chin
china105022483__china
chip116726423__chip
chis95933313__chis
chit96937463__chit
cochin131313203cochin
dacha114812573dach_a
disci85815023disc_i_
discoid11311243discoid
episcia1145123episc_ia
eschar1136523eschar
escheat12410403escheat
eschew1436333eschew
facia103218463fac_ia
fascia1148703fasc_ia
fiaschi1542793fiaschi_
fuchsia15123573fuchsia
ich86227743i_ch__
ichor1039483i_chor
ichs96214713i_ch_s
ictic9311803i_ctic
ilia46026823i__lia
inch95420823inch__
inched124514483inched
incher114114033incher
inches114419673inches
inching134414323inching
inclip1036823inclip
inia45024703i__nia
isatin6412213isatin
isba61310883is__ba
ischaemia1652093ischaemia
ischemias1644183ischemias
ischemic1744673ischemic
ischiadic1751663ischiadic
ischiatic1644293ischiatic
isocheim1543333isocheim
isochime15113843isochime
isochor1244743isochor
isohel935483isohel
issei568573issei_
isseis638563isseis
isthmi1143603isthmi
isthmian1343073isthmian
isthmic1444793isthmic
itch95619173itch__
itched123812023itched
itches114916213itches
itchier12247673itchier
itchily1574493itchily
itching134011683itching
itchy13449013itch_y
ixia115713213i__xia
kachina1637663kachina
kimchi1743803kimchi_
kimchis1843733kimchis
kishka1232963kis_hka
lichi104412953lichi_
lichis115212593lichis
litchi1137893litchi_
litchis1238373litchis
lithia939333lithia
lochial1257083lochial
macchia1645893macchia
milchig1543653milchig
mischief1846413mischief
miscoin11311433miscoin
mishit112618193mis_hit
mocha1249923moch_a
mochila1446523mochila
nitchie1247233nitchie
nucha10229793nuch_a
ohia75719363__ohia
orchid1289573orchid
orchil1158653orchil
orchis11710773orchis
oscula837293oscula
ossia53710403os_sia
ostia52315583os_tia
pacha126518063pach_a
piscina1177043piscina
psychic1944833psychic
rachial122012173rachial
rachis114017653rachis
raphia113511263raphia
rishi8311253ris_hi_
rishis9312453ris_his
sahib10314763_sahib
scena74815783_scena
schav1338313_schav
schema1388373_schema
schism1338173_schism
schist11312653_schist
schizo20115993_schizo
schizy23115043_schizy
schmo124510203_schmo
scholia1237833_scholia
schrik15206703_schrik
schtik15185423_schtik
schuit1139563_schuit
schul102510413_schul
schwas14396983_schwas
scoria8513503_scoria
scotia8310803_scotia
scrim95419743_scrim
scrip96619193_scrip
scuba94211593_scuba
scuta75815753_scuta
sepia75318673_sepia
sha69837783_s_h_a
shea76031573_s_hea
shim95827863_s_him
shin75634313_s_hin
ship95228243_s_hip
shit76745943_s_hit
shiv105721173_s_hiv
shiva115915003_s_hiva
shwa106014963_s_hwa
sickie123715743sickie
stria55723213_stria
techie11511723techie
unchic1338643unchic
uncia75015163unc_ia
urchin1138743urchin
viscera1235083viscera
viscid1237473visc_id
viscoid1337023viscoid
wisha114910853wis_h_a
zechin20137703zechin

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.376475242.0
2DLD Change Limit1127161525.03022408.7
3Display Results1521520.0463304.3
 (SQL Overall)1786911525.45232775.3
 
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.