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

218 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
diapirs1034764(None) 
diapers104713911diapers
diapir9357111diapir_
deairs74013782dea_irs
diacids1137862diacids
dialers83614302dialers
diamins10312212diamins
diaper94513112diaper_
diapiric1344382diapiric
diapsids1244752diapsids
diaries83321952diaries
diazins1739182diazins
dippers123615182dippers
drapers105313352drapers
tapirs84113172_tapirs
airs46447433__a_irs
amirs75924923__amirs
apers76629133__apers
bediapers1444333bediapers
bialies93618413bialies
bialis83617163biali_s
biopics13318543biopics
capers105428143_capers
capias10318353_capias
capris10415083_capris
chairs114916183cha_irs
daikers124010313daikers
dailies84219263dailies
daimios1035753daimios
dairies84217733dairies
dairy97016303d_a_iry
dais57040703d_a_i_s
daisies84217093daisies
damars93815003d_amars
dampers123915693dampers
danios7314603d_anios
daps77239163d_ap__s
darers75921873d_arers
darics94314113d_arics
daters74827373d_aters
davies105020513d_avies
davits104012363d_avits
deair65817193dea_ir_
dealers84118613dealers
dearies83526273dearies
dears65736883dea__rs
despairs1144943despairs
devoirs1175783devoirs
diacid10310633diaci_d
diadems1135393diadems
dialer74315433dialer_
dialing94318173dialing
dialings10329823dialings
dialist8517763dialist
dialists9411413dialists
diallers957773diallers
dialogs938103dialogs
dials64925343dia__ls
diamide1138473diamide
diamides1238823diamides
diamin9312523diami_n
diamine10311983diamine
diamines11311643diamines
diapause1143893diapause
diapered1238003diapered
diapsid1146703diapsid
diarist8517113diarist
diarists9410363diarists
diary95016973dia__ry
diaspora1154403diaspora
diasporas1264443diasporas
diaspore1166063diaspore
diaspores1266543diaspores
diasters92913183diasters
diatoms1039073diatoms
diazin1639163diazi_n
diazine1738933diazine
diazines1838713diazines
dibbers124013173dibbers
dicers94720743di_cers
dickers144117663dickers
dickies143416343dickies
didappers1543173didappers
didies84621833di_dies
diesis74013493diesi_s
dieters83216433dieters
differs14339973differs
digamies1238643digamies
diggers104413393diggers
digits84114533di_gits
dikdiks1242563dikdiks
dikers114418793di_kers
dilaters92513063dilaters
dilators93213203dilators
dillies84122163dillies
dimers94321093di_mers
dimmers123811563dimmers
dimples122813213dimples
dimwits1344513dimwits
dinars75417563di_nars
diners75525953di_ners
dingers94321383dingers
dingies93618243dingies
dinkies123716033dinkies
dinners83915443dinners
diopters1137693diopters
dioptre1055763dioptre
dioptres1146113dioptres
dioxids1655683dioxids
dioxins1568003dioxins
dipper114017793dipper_
dippier123111393dippier
dippiest132511143dippiest
dipping134014833dipping
dips75536923di_p__s
dipsas9359893di_psas
dipsos95310053di_psos
dirties83119383dirties
disbars10310323disbars
diseurs839403diseurs
dismiss1038153dismiss
dispart101115283dispart
disparts11109953disparts
dispels10310503dispels
disperse111011353disperse
dispirit1149203dispirit
dispirits1246153dispirits
disport101015953disport
disports111111113disports
distils83015803distils
dithers114016153dithers
ditties83116983ditties
divers105024963di_vers
divvies1457663divvies
dixits144210313di_xits
dizzies16279753dizzies
dopers95522483d_opers
dorpers104113173dorpers
drails74716953dra_ils
drains73719403dra_ins
draper94315693draper_
drapery13387943drapery
drapes95419653drap_es
draping114213353draping
drawers113610073drawers
drippers13327943drippers
dumpers123412663dumpers
dupers94615603d_upers
dyadics1453473dyadics
elapids1036503elapids
fairs85825443_fa_irs
fakirs13468083_fakirs
faqirs18456033_faqirs
fiars86720833fia__rs
flairs95711913fla_irs
gapers94520473_gapers
giaours834573giaours
gippers123212083gippers
glairs75211333gla_irs
hairs86225173_ha_irs
heapers123616673heapers
hippies142813753hippies
impairs1135823_impairs
impis96213853_impi_s
japers154616173_japers
kafirs13306983_kafirs
kippers153211433kippers
lairs55425873_la_irs
lapins84520683_lapins
lapis76223153_lapi_s
leapers93716663leapers
liars54723163lia__rs
limpers113815223limpers
lipids94310923li_pids
lipins85016883li_pins
lippers113416443lippers
lispers94514323lispers
mairs76228303_ma_irs
midairs1037203midairs
nadirs7109003_nadirs
niacins938543niacins
nippers113012623nippers
okapis1235393okapi_s
pairs75325833_pa_irs
papers105125323_papers
pipers104318663pi_pers
pipits104713063pi_pits
pippins10319753pippins
rapers84327183_rapers
rapids94913893_rapids
rapiers95012873_rapiers
reapers93520453reapers
repairs9319973repairs
rippers114115033rippers
sabirs85414633_sabirs
sapors84118813_sapors
shapers124016893shapers
sialids839723sialids
simpers113014123simpers
sippers113117753sippers
soapers93715923soapers
stairs65416333sta_irs
tapers84025813_tapers
tapir75917063_tapir_
tapis75028863_tapi_s
tiepins939463tiepins
tilapias1045293tilapias
tipis76019923ti_pi_s
tippers113414353tippers
vairs85019133_va_irs
vapors113812693_vapors
viators102712033viators
vipers114914533vi_pers
vizirs18306713vi_zirs
wairs86424063_wa_irs
wipers115416083wi_pers
yippies14279293yippies
zippers203310383zippers

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.500357382.0
2DLD Change Limit1340272186.45320769.7
3Display Results2182180.0932344.1
 (SQL Overall)1786912187.04625360.6
 
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.