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 “midterm” 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
midterm1231601(None) 
midterms13284861midterms
misterm114314511misterm
milter84921232milter_
milters93619092milters
minter84425102minter_
minters93822472minters
mister84728562mister_
misterms123711352misterms
misters93927512misters
miter75734792mi_ter_
miters84328782mi_ters
aider65431133aid_er_
aiders74524633aid_ers
bidder104114863bidder_
bidders114012313bidders
bider85728373bid_er_
biders94822803bid_ers
bioherm1434653bioherm
bister84922763bister_
bisters93922613bisters
biter75030033bi_ter_
biters83925243bi_ters
bitter84622673bitter_
bittern94810683bittern
bitters94920363bitters
cider84723313cid_er_
ciders94620093cid_ers
cistern93310703cistern
citer74827333ci_ter_
citers85022983ci_ters
cittern9339143cittern
derm76031893__d_erm
dieter73516773dieter_
dieters83216433dieters
diptera1037213diptera
eider64624743eid_er_
eiders74321363eid_ers
emitter93211083emitter_
emitters10349643emitters
epiderm1236193epid_erm
filter94517633filter_
filters103816553filters
fitter94120033fitter_
fitters104517753fitters
gittern8337503gittern
hider95024083hid_er_
hiders104919653hid_ers
hinter94021303hinter_
hinters103719583hinters
hitter94419863hitter_
hitters104717593hitters
idem76121063_id_e_m
idler65015663_idler_
idlers74012813_idlers
inter55028493_inter_
interim9912873_interim
intern64016543_intern
inters64328053_inters
item65620383_i_te_m
iterum837903_i_terum
jilter133512513jilter_
jilters144211963jilters
jitter133314993jitter_
jitters144314473jitters
jittery17346443jittery
kidder123811093kidder_
kidders13399173kidders
kilter103714343kilter_
kilters113813603kilters
kiter95523213ki_ter_
kiters105218593ki_ters
lifter93814813lifter_
lifters104313783lifters
linter64625343linter_
linters73822633linters
lister64527253lister_
listers74026533listers
liter54736343li_ter_
liters65429883li_ters
litter64324853litter_
litters73422573litters
littery103710493littery
madder103515593madder_
madders113513213madders
madtom1138023madt_om
master84831343master_
masters94628923masters
mastery124214323mastery
mater74438863m_ater_
maters85032393m_aters
matter84325343matter_
matters94421753matters
mattery123810713mattery
meeter83616503meeter_
meeters94714543meeters
meister93114163meister_
meisters103313843meisters
melter83520113melter_
melters93918313melters
meter75130323m_eter_
meters85625833m_eters
midair937993midair_
midairs1037203midairs
midden104112853midde_n
middens11379383middens
middler112712273middler_
middlers123410193middlers
midge95016543midge__
midges103516473midge_s
midget103718443midge_t
midgets113910253midgets
midleg1038553midle_g
midlegs1156323midlegs
midstory1445103midstory
midstream1443573midstream
midtown1343673midtown
midweek1743273midweek
midyear1343343midyear
midyears1443403midyears
milder93818453milder_
miler75733063mi_ler_
milers84625163mi_lers
milker124814323milker_
milkers134411613milkers
miller84625413miller_
millers93621343millers
milted93919943milte_d
miltier93214963miltier_
mimer94825763mi_mer_
mimers105520183mi_mers
mincer104017363mincer_
mincers113714853mincers
minder94822503minder_
minders103720123minders
miner76933543mi_ner_
miners84126633mi_ners
minster93914323minster_
minsters103813923minsters
minted94220583minte_d
mintier93615993mintier_
minuter93510413minuter_
mirier83918363mirier_
mirker123712693mirker_
misdeem12217873misdeem
misdoer1048633misdoer_
misdoers1137103misdoers
miser75430403mi_ser_
misers85025703mi_sers
misery114113543mi_sery
misform1437513misform
misted93625823miste_d
mistend103812523mistend
mistermed1438363mistermed
misteuk1335893misteuk
mistier93418713mistier_
mite66249413mi_te__
mitered103213233mi_tered
miterer92511333mi_terer
mites75141803mi_te_s
mither114218563mither_
mithers123516733mithers
mitier83620673mitier_
mitre75522423mi_t_re
mitred94414343mi_tred
mitres83922073mi_tres
mitten83914093mitte_n
mittens9349883mittens
mixer145017643mi_xer_
mixers154513563mi_xers
mixture1635413mixture
modem103717143mod_e_m
modern939523mod_ern
moister94015373moister_
molter84119423molter_
molters93816973molters
montero9310133montero
mooter83921093mooter_
mooters93818623mooters
mudder104413493mudder_
mudders113211113mudders
muster84724523muster_
musters94522513musters
muter74525543m_uter_
mutter84418883mutter_
mutters94117143mutters
mystery15436523mystery
niter55028973ni_ter_
niters64624213ni_ters
nitery94412173ni_tery
omitter9298503omitter_
omitters10277653omitters
preterm11310153preterm
ridder84015143ridder_
ridders93612493ridders
rider65231303rid_er_
riders74123903rid_ers
rioter64817283rioter_
rioters73615513rioters
ritter63822423ritter_
ritters74020623ritters
sidearm1035963sidearm
sidler74716963sidler_
sidlers83414233sidlers
sifter94516233sifter_
sifters103714793sifters
sinter63625923sinter_
sinters74024083sinters
sister64421583sister_
sisters73721593sisters
sitter63323383sitter_
sitters74221553sitters
smiter83616413smi_ter_
smiters93414363smi_ters
term66233153___term
tidier73515113tidier_
tidiers8389773tidiers
tilter63417693tilter_
tilters73315953tilters
tinter63923643tinter_
tinters74221113tinters
titer55430613ti_ter_
titers64526413ti_ters
titter63421163titter_
titters74219623titters
widder112913973widder_
widders123512273widders
wider94826353wid_er_
winter94222803winter_
winters103720483winters
wintery13399753wintery

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.1531167915.0
2DLD Change Limit1340272316.61020276.4
3Display Results2312310.0802887.5
 (SQL Overall)1786912316.84326113.0
 
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.