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

231 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
schisms143717(None) 
schism1338171schism_
schists1248541schists
chasms135513142_chasms
chiasms14357522_chiasms
chirms135113982_chirms
chrisms1499142_chrisms
echoisms1546142echoisms
sadisms10359112sadisms
schist11312652schis_t
schizos21115432schizos
schuss11186732schus_s
scrims104615932scri_ms
seisms84912142s_eisms
sexisms16226222sexisms
shims104422542s_hi_ms
shists96515102s_hists
sophisms1546652sophisms
tachisms1567142tachisms
ageisms1056603ageisms
agisms9399393_agisms
archaisms1646073archaisms
atheisms1346923atheisms
autisms94311553autisms
chaises124317493_chaises
chams126028503_ch_ams
charisms15710263_charisms
charms135218843_charms
chases115128233_chases
chasm125518793_chasm_
chasmy16468543_chasmy
chemisms17278213_chemisms
chess105016923_ches_s
chests114916263_chests
chias104625523_chi_as
chiasm13449103_chiasm_
chiasma14366993_chiasma
chiasmas15306593_chiasmas
chiasmi14365583_chiasmi
chiasmus15343913_chiasmus
chiaus113611313_chiaus
chicas135916473_chicas
chicks175317593_chicks
chicos134614833_chicos
chics123920943_chi_cs
chides124620473_chides
chiefs14509653_chiefs
chiels115115933_chiels
chiles115425303_chiles
chilis115517873_chilis
chills114717703_chills
chimb144813563_chi_mb
chimbs153910303_chimbs
chime125322593_chi_me
chimes134922573_chimes
chimp145216473_chi_mp
chimps155713663_chimps
chinas115119403_chinas
chines115029173_chines
chinks155817573_chinks
chinos115018693_chinos
chins105631463_chi_ns
chints115117833_chints
chips125721253_chi_ps
chirks155414843_chirks
chirm125317063_chirm_
chiros114617773_chiros
chirps135414003_chirps
chirrs114514983_chirrs
chirus114615693_chirus
chis95933313_chi__s
chisel112111943_chisel
chisels12219103_chisels
chits105424573_chi_ts
chives144317593_chives
choses115825133_choses
chrism13710673_chrism_
chrisma1456823_chrisma
chrisoms1566093_chrisoms
chums125015833_ch_ums
cists76624533_c_ists
civisms1436073civisms
crises84529433_crises
crisis83716343_crisis
crisps104411513_crisps
cubisms13306883cubisms
deisms94411043_deisms
echinus1236203echinus
echoism1447363echoism_
egoisms1065953egoisms
eonisms92811043eonisms
escapisms1543943escapisms
fascisms1545663fasc_isms
favisms1535443favisms
hims95230973__hi_ms
hiss75629213__his_s
hists86328373__hists
holisms123811113holisms
iodisms10308483iodisms
ischium1444243ischium_
isms66213473___isms
jisms14458003__jisms
locoisms1256143locoisms
lyrisms1235653lyrisms
machismo1754203machismo
machismos1863053machismos
machoisms1845193machoisms
masochisms1953503masochisms
momisms10308223momisms
monisms113512803monisms
mutisms11338453mutisms
nanisms938833nanisms
nomisms11268743nomisms
nudisms10305853nudisms
obiisms1135673obiisms
ogrisms1036443ogrisms
orchises1338773orchises
orphisms1545993orphisms
pachisis15268823pachisis
papisms13238543papisms
porisms113713453porisms
prisms104915503_prisms
purisms114110833purisms
rachises131412413rachises
racisms112310813racisms
sachems14348903sach_ems
sacrists1039563sacrists
sadism94113493sadism_
sadists83310853sadists
sahibs1137083sahi_bs
sapphisms1843523sapphisms
scams94423973sc__ams
schavs1436493sch_avs
schema1388373sch_ema
schemas1468163schemas
scheme1379633sch_eme
schemes1489663schemes
schistose1443503schistose
schistous1443863schistous
schizo20115993schi_zo
schizy23115043schi_zy
schizzy23132363schizzy
schleps1445483schleps
schlubs1443193schlubs
schlump1643263schlump
schlumps1742743schlumps
schmo124510203sch__mo
schmoes14308543schmoes
schmoos14347513schmoos
schmos13379153sch_mos
schnaps1443703schnaps
scholiums1644843scholiums
schools1249113schools
schorls1248353schorls
schriks16185743schriks
schrods1337433schrods
schticks19193953schticks
schtiks16184743schtiks
schuits1235823schuits
schuls11299853sch_uls
schusses1334213schusses
schwas14396983sch_was
sciolisms1346223sciolisms
scions82612243sc_ions
scouses93313243scouses
scrams105216623sc_rams
screams114810613screams
scribes113713203scribes
scries85226823scri_es
scrim95419723scri_m_
scrimp125110583scri_mp
scrimps13517903scrimps
scrips105316033scri_ps
scripts11509373scripts
scrives124414273scrives
scrums104614253sc_rums
scums95017423sc__ums
seises64026713s_eises
seism75019023s_eism_
semises93916553semises
sexism15227653sexism_
sexists14267673sexists
shams105829413s_h_ams
shawms14579563s_hawms
shiels95418923s_hiels
shiers94921753s_hiers
shies86136553s_hi_es
shifts124412933s_hifts
shiksas1484643s_hiksas
shikses14116573s_hikses
shills94519613s_hills
shim95827853s_hi_m_
shimmy16306413s_himmy
shines95028913s_hines
shins85131043s_hi_ns
ships105123773s_hi_ps
shires95225573s_hires
shirks134814123s_hirks
shirrs94413173s_hirrs
shirts94918333s_hirts
shist84829603s_his_t
shits84731163s_hi_ts
shivas124512413s_hivas
shives124921413s_hives
shivs115018803s_hi_vs
sims65737173s__i_ms
sises55233833s__ises
skims114517183s_ki_ms
slims75423653s_li_ms
slumisms1244723slumisms
sodiums10177213sodiums
sophism1437863sophism_
sophists1347293sophists
spasms10418973s_pasms
speises93813933speises
speiss84311643speis_s
squirms18376333squirms
statisms1039543statisms
swims105514143s_wi_ms
swiss86712903s_wis_s
tachism1478873tachism_
tachisme1554693tachisme
tachismes1684223tachismes
tachists1348183tachists
theisms1237763theisms
truisms9106823truisms
tsarisms1056653tsarisms
verisms123011253verisms
whims134515333_whi_ms
whisks16497353_whisks
whists124613813_whists

Search took 8 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.1561145455.1
2DLD Change Limit1340272317.50017870.3
3Display Results2312310.0763039.5
 (SQL Overall)1786912317.73223110.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.