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

235 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
schemas146816(None) 
schema1388371schema_
schemes1489661schemes
chelas113817202_chelas
chemos13311722_chemos
eczemas2063142eczemas
ischemias1644182ischemias
sachems14348902sachem_s
scenas84114702sc_enas
schemata1545002schemata
scheme1379632schem_e
schemed1577752schemed
schemer1477962schemer
schemers1576712schemers
schmear1484042schmear
schmears1584102schmears
schmos13379152sch_mos
schwas14396982sch_was
scleras948222scleras
screams114810622screams
shamas113717942s_hamas
sheas86331792s_he_as
achenes12313493achenes
aches106132293ache__s
asthmas12117363asth_mas
bemas96424283__bemas
boheas114013213bohe_as
bohemias1545983bohemias
caeomas1138403_caeomas
camas96333523_c_amas
chacmas1638003_chacmas
champs154915683_champs
chams126028503_cham_s
charas114223613_charas
cheap126915943_che_ap
cheaps134613683_cheaps
cheat105732453_che_at
cheats114519543_cheats
checks174912703_checks
cheeks154712783_cheeks
cheeps135312913_cheeps
cheers114518913_cheers
chefs136214663_che_fs
chela103916803_chela_
chelae113614603_chelae
chemic153012093_chemic
chemics16349583_chemics
chemise143211503_chemise
chemism16339303_chemism
chemist143615003_chemist
chemo12313633_chem_o
cherts115617233_cherts
chess105016923_che_ss
chests114916263_chests
chetah14399583_chetah
chetahs15347073_chetahs
cheths14389823_cheths
chews135418513_che_ws
chias104625523_ch_ias
chicas135916473_chicas
chimar133911473_chimar
chimars144010593_chimars
chimbs153910303_chimbs
chimes134922573_chimes
chimlas1437453_chimlas
chimps155713663_chimps
chinas115119403_chinas
cholas114818003_cholas
chomps155112223_chomps
chromas142512693_chromas
chufas14397673_chufas
chumps154313823_chumps
chums125015833_chum_s
chymes165912153_chymes
cinemas1138043cinemas
comas95833003_c_omas
commas124814573_commas
creams104715253_creams
cremes104517993_cremes
cymas126417883_c_ymas
eches106322163eche__s
eczema1973073eczema_
edemas9310503_edemas
enemas8812003_enemas
escheat12410403esche_at
escheats1346253escheats
eschewal1643133eschewal
eschewals1742623eschewals
eschews1534553esche_ws
hemal104419803__hemal
hemes105031083__hemes
hemps126917333__hemps
hems95534943__hem_s
iceman1037853ic_eman
ischaemias1752043ischaemias
ischemia1544073ischemia
ischemic1744673ischemic
khedas1446313_khedas
kinemas1336893kinemas
nemas75321573__nemas
ochers113915303oche_rs
oedemas1056693oedemas
pschents1544113pschents
rehems113410983rehem_s
rheas84816953_rhe_as
rhemes115913183_rhemes
sachem134012223sachem__
sachemic1746083sachemic
sachets123914103sache_ts
saphenas1345713saphenas
scamps125014173sc_amps
scams94423973sc_am_s
scena74815783sc_ena_
scends95213003sc_ends
scenes84520353sc_enes
scents85317023sc_ents
schav1338313sch__av
schavs1436493sch_avs
schematic1847843schematic
schematics1945673schematics
schematism1944713schematism
scheming1636633scheming
scherzi2143583scherzi
scherzo2153943scherzo
scherzos2243703scherzos
schisms1437173schisms
schists1248543schists
schizos21115433schizos
schlepps1762563schlepps
schleps1445483schleps
schlubs1443193schlubs
schlumps1742743schlumps
schmalz2345293sch_malz
schmeer1475363schmeer
schmeers1574833schmeers
schmo124510203sch_m_o
schmoe13328333sch_moe
schmoes14308543schmoes
schmoos14347513schmoos
schnaps1443703schnaps
scholar1236953scholar
scholars1336683scholars
schools1249113schools
schorls1248353schorls
schriks16185743schriks
schrods1337433schrods
schtiks16184743schtiks
schuits1235823schuits
schuls11299853sch_uls
schuss11186733sch_uss
schwa13426843sch_wa_
scillas9310473scillas
sclera838893sclera_
sclerae937933sclerae
scleral937863scleral
scleromas1364313scleromas
scotias939753scotias
scotomas1256263scotomas
scrams105216623scram_s
screak125311063scre_ak
screaks13469363screaks
scream104814253scre_am
screeds106210293screeds
screens95212183screens
screes85023973scre_es
screws115513893scre_ws
scrimps13517903scrimps
scrims104615933scrim_s
scrums104614253scrum_s
scubas103710223sc_ubas
scums95017423sc_um_s
seams75731663s__eams
seas45755273s__e_as
seems75525023s_eem_s
sememes11109203sememes
semes75731583s__emes
semis74623533s__emis
senecas939013senecas
senegas837253senegas
seriemas1047193seriemas
shaman113314283s_haman
shamans123610903s_hamans
shames114726223s_hames
shammas14358723shammas
shamos114216983s_hamos
shams105829413s_ham_s
shamus114112813s_hamus
shea76031573s_he_a_
sheaf115424123s_he_af
sheafs124912883s_heafs
sheal84927703s_he_al
sheals94420643s_heals
shear85424833s_he_ar
shears93820903s_hears
sheds96122703s_he_ds
sheens95116993s_heens
sheers94322403s_heers
sheets93918503s_heets
sheiks132510013s_heiks
sheilas1059403s_heilas
shells94319523s_hells
sheltas10279673s_heltas
shends105313773s_hends
sheols94614163s_heols
sherds105614723s_herds
sherpas1238093s_herpas
shes75734353s_he__s
shews115924713s_he_ws
shims104422553s_him_s
shivas124512413s_hivas
shmear1176933s_hmear
shmears1277073s_hmears
shwas116415103s_h_was
sideman1037973sideman
sigmas94111363s_igmas
simas75727553s__imas
smegmas1233503smegmas
sokeman1337263sokeman
somas76030373s__omas
sphenes123013163sphenes
spheral1238423spheral
spheres123114353spheres
steams84916903s_teams
stemmas11256973stemmas
stems75219953s_tem_s
sthenias1178163sthenias
stigmas10206643stigmas
stomas84816323s_tomas
streams94713373streams
strumas9419833strumas
summas104313163s_ummas
themes115319253_themes
thetas93011573_thetas
ulemas888963_ulemas
whenas124610463_whenas

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272356.01322289.5
3Display Results2352350.0802937.5
 (SQL Overall)1786912356.49927495.2
 
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.