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

275 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
schema138837(None) 
schemas1468161schemas
scheme1379631scheme
chela103916802_chela
chemo12313632_chemo
eczema1973072eczema
ischemia1544072ischemia
sachem134012222sachem_
sachems14348902sachems
scena74815782sc_ena
schemata1545002schemata
schemed1577752schemed
schemer1477962schemer
schemes1489662schemes
schmear1484042schmear
schmo124510202sch_mo
schwa13426842sch_wa
sclera838892sclera
scream104814252scream
shea76031572s_he_a
aceta74017353ac_eta
ache96829823ache__
ached119227833ache_d
achene11313813achene
aches106132293ache_s
ahem97225363_ahem_
alchemy1743113alchemy
asthma11126563asth_ma
bema85825253__bema
bohea105013733bohe_a
bohemia1446363bohemia
caeca93915133_caeca
caeoma1039033_caeoma
ceca84820783_c_eca
chacma1537903_chacma
chaeta11310683_chaeta
cham115532313_cham_
champ145017963_champ
chams126028503_chams
cheap126915943_cheap
cheat105732453_cheat
check164714713_check
cheek145115713_cheek
cheep125416503_cheep
cheer105420383_cheer
chef125125623_che_f
chefs136214663_chefs
chelae113614613_chelae
chelas113817203_chelas
chemic153012093_chemic
chemos13311723_chemos
chert105232103_chert
chess105016923_chess
chest104926143_chest
chetah14399583_chetah
cheth135013823_cheth
chevy16479993_chevy
chew126622133_che_w
chews135418513_chews
chewy165011903_chewy
chez184519023_che_z
chia96026623_ch_ia
chica125818263_chica
chimar133911473_chimar
chimb144813563_chimb
chime125322593_chime
chimla1337593_chimla
chimp145216473_chimp
china105022483_china
chola104718033_chola
chomp144815663_chomp
chroma132912473_chroma
chufa13489113_chufa
chum116318003_chum_
chump145315443_chump
chums125015833_chums
chyme156512503_chyme
cinema1047653cinema
coma87134853_c_oma
comma114514793_comma
cream95721353_cream
creme94319323_creme
cyma116715843_c_yma
eche97520283eche__
eched116919223eche_d
eches106322163eche_s
ecthyma1752613ecthyma
eczemas2063143eczemas
edema8610553_edema
enema7612743_enema
escheat12410413escheat
eschew1436333esche_w
eschewal1643133eschewal
eschews1534553eschews
hem86148733__hem_
hemal104419803__hemal
heme95034413__heme
hemp115725623__hemp
hems95534943__hems
herma105318883__herma
iceman1037853ic_eman
ischaemia1652093ischaemia
ischemias1644183ischemias
ischemic1744673ischemic
ischia1136393isch_ia
kheda1346543_kheda
kinema1236023kinema
nema65522523__nema
ocher104516103oche_r
ochers113915303ochers
ochery14319443ochery
ochrea11316643ochrea
ocrea73311823ocre_a
oedema936573oedema
pschent1437413pschent
rehem103815353rehem_
rehems113410983rehems
rhea75017433_rhe_a
rheme106214053_rheme
sachemic1746083sachemic
sachet114725773sache_t
sachets123914103sachets
saphena1235863saphena
satem76021463satem_
scam85932353sc_am_
scamp115717313sc_amp
scams94423973sc_ams
scenas84114703sc_enas
scend85516293sc_end
scene77220573sc_ene
scent75831623sc_ent
schav1338313sch_av
schavs1436493schavs
schematic1847843schematic
schemers1576713schemers
scheming1636633scheming
scherzi2143583scherzi
scherzo2153943scherzo
schism1338173schism
schisms1437173schisms
schist11312653schist
schizo20115993schizo
schizy23115043schizy
schlep1347093schlep
schlepp1662953schlepp
schleps1445483schleps
schlub1355003schlub
schlump1643263schlump
schmalz2345293sch_malz
schmears1584103schmears
schmeer1475363schmeer
schmoe13328333schmoe
schmos13379153schmos
schnoz2035653schnoz
scholar1236953scholar
scholia1237833scholia
school11410723school
schorl1179813schorl
schrik15206703schrik
schrod1247883schrod
schtik15185423schtik
schuit1139563schuit
schul102510413sch_ul
schuln11256233schuln
schuls11299853schuls
schuss11186733schuss
schwas14396983schwas
scilla8310943scilla
sclerae937933sclerae
scleral937863scleral
scleras948223scleras
scleroma1274353scleroma
scoria8513503scoria
scotia8310803scotia
scotoma1155963scotoma
scram910621623scram_
scrams105216623scrams
screak125311063screak
screams114810623screams
scree720031713scre_e
screed95718933screed
screen85216023screen
screes85023973screes
screw109318543scre_w
screws115513893screws
screwy14659463screwy
scrim95419743scrim_
scrimp125110583scrimp
scrims104615933scrims
scrota8310203scrota
scrum95418203scrum_
scrums104614253scrums
scuba94211593sc_uba
scum85924523sc_um_
scummy15265223scummy
scums95017423sc_ums
scuta75815753sc_uta
sea36161293s__e_a
seam66645973s__eam
seem65438563s_eem_
seems75525023s_eems
seme65836653s__eme
sememe10129983sememe
semi65127223s__emi
seneca839793seneca
senega738173senega
sera46141393s__era
seriema938403seriema
seta45637313s__eta
sha69837783s_h__a
sham96436363s_ham_
shaman113314283s_haman
shamas113717943s_hamas
shame105726703s_hame
shams105829413s_hams
she66837693s_he__
sheaf115424123s_heaf
sheal84927703s_heal
shear85424833s_hear
sheas86331793s_heas
shed86536153s_he_d
sheds96122703s_heds
sheen85023313s_heen
sheep105321523s_heep
sheer84726893s_heer
sheet84836963s_heet
sheik122514663s_heik
sheila969843s_heila
shelf115221113s_helf
shell84424123s_hell
shelta93111793s_helta
shend94719973s_hend
shent85933503s_hent
sheol84318373s_heol
sherd96321153s_herd
sherpa1138093s_herpa
shes75734353s_he_s
shew108030763s_he_w
shewn115715703s_hewn
shews115924713s_hews
shim95827863s_him_
shims104422553s_hims
shiva115915003s_hiva
shmear1176933s_hmear
shmo95318103s_h_mo
shwa106014963s_h_wa
sideman1037973sideman
sigma84513833s_igma
sima64730793s__ima
smegma1134113smegma
sokeman1337263sokeman
solemn838643solemn
soma65635293s__oma
sphene113412403sphene
spheral1238423spheral
sphere113313663sphere
sphery14318883sphery
squama1736533squama
steam76322933s_team
stela54019043s_tela
stem610628253s_tem_
stemma10328133stemma
stems75219953s_tems
sthenia1058503sthenia
stigma9226763stigma
stoma75918273s_toma
stream84717293stream
stroma84313073stroma
struma84313273struma
summa94713313s_umma
theca103311453_theca
them97427043_them_
theme105921733_theme
theta83414573_theta
ulema7109713_ulema

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.423422437.4
2DLD Change Limit1127162755.84319290.8
3Display Results2752750.0932957.0
 (SQL Overall)1786912756.35928100.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.