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

164 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
schizo2011599(None) 
schizos21115431schizos
schizy23115041schizy
chiao105618362_chiao
chico124218252_chico
chino105823312_chino
chiro105320342_chiro
scherzo2153942scherzo
schism1338172schism
schist11312652schist
schizoid2344352schizoid
schizont2244712schizont
schizzy23132362schizzy
schmo124510202sch_mo
schnoz2035652schnoz
achier113914263achier
aching126521973aching
achoo10315083ach_oo
chao95727313_ch_ao
chemo12313633_chemo
chez184519023_chez_
chi86228653_chi__
chia96026623_chi_a
chias104625523_chias
chic115925203_chi_c
chica125818263_chica
chick165419133_chick
chicos134614833_chicos
chics123920943_chics
chid106626403_chi_d
chide115321013_chide
chief134419483_chief
chiel104918973_chiel
chigoe1237533_chigoe
child114516223_child
chile105626893_chile
chili106218483_chili
chill105619873_chill
chimb144813563_chimb
chime125322593_chime
chimp145216473_chimp
chin96934743_chi_n
china105022483_china
chine105231723_chine
chink145321593_chink
chinos115018693_chinos
chins105631463_chins
chip116726423_chi_p
chips125721253_chips
chirk144516183_chirk
chirm125317063_chirm
chiros114617773_chiros
chirp124717163_chirp
chirr105015903_chirr
chiru105317153_chiru
chis95933313_chi_s
chit96937463_chi_t
chiton112612393_chiton
chits105424573_chits
chive135117623_chive
chivy164810363_chivy
cholo105217973_cholo
chorizo2136323_chorizo
ciao64924183_c_iao
eching126315563eching
echini114710433echini
echo96615953ech__o
ischia1136393ischi_a
ischial1246423ischial
ischium1444243ischium
phiz186718843_phiz_
rhino84614323_rhino
sahib10314763sahi_b
sahibs1137083sahibs
schav1338313sch_av
schavs1436493schavs
schema1388373schema
scheme1379633scheme
scherzi2143583scherzi
scherzos2243703scherzos
schisms1437173schisms
schists1248543schists
schizier2234063schizier
schizoids2443383schizoids
schizonts2342463schizonts
schizopod26142533schizopod
schlep1347093schlep
schlub1355003schlub
schmoe13328333schmoe
schmoos14347513schmoos
schmos13379153schmos
schnook1654483schnook
schnozz2042733schnozz
school11410723school
schorl1179813schorl
schrik15206703schrik
schriks16185743schriks
schrod1247883schrod
schtick18194523schtick
schtik15185423schtik
schtiks16184743schtiks
schuit1139563schuit
schuits1235823schuits
schul102510413sch_ul
schuln11256233schuln
schuls11299853schuls
schuss11186733schuss
schwa13426843sch_wa
schwas14396983schwas
scion72214993sc_ion
scribe104613533scribe
scried95817303scried
scries85226823scries
scrim95419743scri_m
scrimp125110583scrimp
scrims104615933scrims
scrip96619193scri_p
scrips105316033scrips
script105717903script
scrive115414943scrive
scudo85412213sc_udo
scuzz1537573sc_uzz
scuzzy1933083scuzzy
seize143819503s_eize
seizor15428533s_eizor
shako125516093s_hako
shied96125493s_hied
shiel811023773s_hiel
shier85428943s_hier
shies86136553s_hies
shift114225143s_hift
shill85325333s_hill
shily115222013s_hily
shim95827863s_hi_m
shims104422553s_hims
shin75634313s_hi_n
shine85533093s_hine
shins85131043s_hins
shiny115122143s_hiny
ship95228243s_hi_p
ships105123773s_hips
shire84727133s_hire
shirk124817843s_hirk
shirr84716923s_hirr
shirt84533903s_hirt
shist84829613s_hist
shit76745943s_hi_t
shits84731173s_hits
shiv105721173s_hi_v
shiva115915003s_hiva
shive114423423s_hive
shivs115018803s_hivs
shmo95318103s_h_mo
shoo75929893s_h_oo
silo46037913s__ilo
size135630963s__ize
sizy164816393s__izy
skimo116312543s_kimo
sleazo15257523sleazo
sphinx1866203sphinx
subito8410453subito
thio77225413_thi_o
whiz195919943_whiz_
whizz194210323_whizz

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 Limit1127161645.11022057.9
3Display Results1641640.0463565.2
 (SQL Overall)1786911645.52932318.9
 
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.