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

240 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
midair93799(None) 
midairs1037201midairs
impair1036002impair
lidar6312722lida_r
mair66133782m__air
midi75628482mid_i_
midis85923412mid_is
midrib1138242midrib
misaim10311852misaim
mohair1135202mohair
affair1234353affair
aider65431133aid_er
air38058393___air
amidase1036733amidase
amidic114012873amid_ic
amidin94015673amid_in
bidder104114863bidder
bider85728373bid_er
bidi78226593bid_i_
bidis86721143bid_is
cedar84014323ceda_r
chair105519633_chair
cider84723313cid_er
cigar8911803ciga_r
dairy97016303__dairy
dais57040703__dais
deair65817193_deair
diapir9357113diapir
didact10711203didact
didie74120563did_ie
dinar66319893dina_r
disdain938513disdain
eclair836813eclair
eider64624743eid_er
fair76332523__fair
fiar76427333fi_a_r
filar84819293fila_r
flair86114123_flair
giddier10308723giddier
glair65313553_glair
hair76330143__hair
hider95024083hid_er
hilar85418143hila_r
idler65015663_idler
imidic11358203imid_ic
impairs1135823impairs
izar136616013_iza_r
jemidar1744163jemida_r
kidder123811103kidder
kiddie12359393kiddie
kidvid1535023kidvid
lair45934153__lair
liar47229683li_a_r
lidars7310783lidars
litai55216363litai_
maar66025063m__aar
madam10316223mada_m
madame1139853madame
madams11310943madams
madder103515593madder
madeira1045103madeira
maftir1136493maftir
maid75537663m__aid
mail65543453m__ail
maim85831493m__aim
main65345523m__ain
mairs76228303m__airs
makar115614973maka_r
malar76424443mala_r
mar57965953m__a_r
medaka1336343medaka
medal86221333meda_l
medals94218053medals
media84721713med_ia
mediad104313713mediad
mediae94217413mediae
medial93819863medial
median94117543median
medias93620783medias
medic104619653med_ic
medii84513493med_ii
medlar93010463medlar
memoir1037213memoir
menhir1136783menhir
miaou7513083mi_aou
miaow1058353mi_aow
miasm91211093mi_asm
miaul71612123mi_aul
mica86428253mica__
micas96823053mica_s
mid67354473mid___
midbrain1343923midbrain
midcap1336473midcap
midday13327503midday
middays14335663middays
midden104112853midden
middies113116153middies
middle103414983middle
middler112712273middler
middy124812593mid_dy
midge95016553mid_ge
midges103516483midges
midget103718453midget
midgut103510053midgut
midiron1046003mid_iron
midland1136613midland
midleg1038553midleg
midlife13248303midlife
midlifer14215793midlifer
midline102315103midline
midlist10312513midlist
midrash1335423midrash
midribs1235513midribs
midriff1645513midriff
mids76541793mid__s
midship1546043midship
midsize1946393midsize
midst85922553mid_st
midsts95510053midsts
midterm12316013midterm
midway15327153midway
midways16386183midways
midwife16225523midwife
midyear1343343midyear
miffier1537023miffier
mikado1344513mikado
miladi938883miladi
miladis1049823miladis
milady1236613milady
milage93414123milage
milder93818453milder
miler75733063mi_ler
milia72719573mi_lia
miliary1249463miliary
milker124814323milker
milkier133411163milkier
miller84625413miller
millier93716703millier
milter84921233milter
miltier93214963miltier
mimbar1297493mimbar
mimer94825763mi_mer
mimic111414323mi_mic
mina65136923mina__
minae75627723mina_e
minas75434113mina_s
mincer104017363mincer
mincier113512473mincier
minder94822503minder
miner76933543mi_ner
mingier103815293mingier
mini65634563mi_ni_
minim97321603mi_nim
minis75432993mi_nis
minor74920063mi_nor
minter84425103minter
mintier93615993mintier
miosis83615163miosis
miotic103715753miotic
mir57046773m___ir
mirador1046503mirador
mirage92313653mirage
miri66730373mi_ri_
mirier83918363mirier
mirin75023153mi_rin
mirker123712693mirker
mirkier13319053mirkier
mirror848003mirror
misact10316693misact
misadd1037163misadd
misaims11310113misaims
misate81222693misate
misaver1249813misaver
misdate101413963misdate
misdial1039643misdial
misdid10510573misdid
misdoer1048633misdoer
miser75430403mi_ser
misfire12229893misfire
misfit112813833misfit
mishit112618203mishit
mislaid1039303mislaid
mislain9311243mislain
mislie83219153mislie
mislit83019693mislit
missaid10310303missaid
missis84417503missis
mister84728563mister
mistier93418713mistier
miter75734793mi_ter
mither114218563mither
mitier83620673mitier
mitis75425993mi_tis
mixer145017643mi_xer
modal85919243moda_l
modals93914453modals
modi76826313mod_i_
mohairs1234953mohairs
moirai886913moirai_
molar75223093mola_r
mosaic10311143mosaic
mudder104413493mudder
muddier114110023muddier
mylar105311533myla_r
nadir61012973nad_ir
nidal65217103nida_l
nidate7313783nidate
nidi56524403nid_i_
oidia6314953oid_ia
ordain7810403ordain
pair66031513__pair
pidgin10259813pidgin
pilar75221503pila_r
qindar16317173qinda_r
radar61316723rada_r
repair84011463repair
ridder84015143ridder
rider65231303rid_er
ridgier937883ridgier
ridgil8316823ridgil
siddur834573siddur
sidler74716963sidler
simar74920813sima_r
sirdar7269103sirda_r
sitar54820543sita_r
sizar145214993siza_r
smidgin11335103smidgin
stair54719943_stair
tidal64516443tida_l
tidbit938493tidbit
tidier73515113tidier
unfair936233unfair
unhair937333unhair
vair75624143__vair
vicar10513863vica_r
vizir17359393vi_zir
wair75830053__wair
widder112913973widder
widdie113410733widdie
wider94826353wid_er

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.390458182.1
2DLD Change Limit1127162404.72023880.5
3Display Results2402400.0763157.9
 (SQL Overall)1786912405.18634456.4
 
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.