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

268 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
expire153802(None) 
empire1039321empire
expired1736401expired
expirer1635991expirer
expires1638681expires
expiry1834651expiry
aspire8612122aspire
empires1139852empires
entire61617702entire
excide1638422excide
excise1538552excise
excite15310882excite
exile126117652ex_ile
exine125518492ex_ine
expert15515352expert
expiate16910592expiate
expirers1735122expirers
expiries1747752expiries
explore1646612explore
export15412182export
expose1549522expose
respire9411542respire
spire75828692_spire
umpire1047892umpire
admire949933admire
afire86215913_afire
alpine84417373alpine
ampere10514413ampere
aspired1068173aspired
aspirer967903aspirer
aspires9612043aspires
attire62412383attire
axile126020513ax_ile
axite125218253ax_ite
axlike17388853axlike
bemire103312803bemire
cire65836373__cire
copier103722893copier
desire7415303desire
despise1038683despise
despite10410123despite
dexie134716893dex_i_e
dire56644143__dire
dopier93515923dopier
eagre64315323e_agre
easier64218463easier
edgier8469733edgier
edile64819493e_dile
eelier64216463eelier
eerie55228533eeri_e
eerier64320023eerier
eide55832243e__ide
elapine9310673elapine
elide64922643e_lide
elite56230183e_lite
elmier839813elmier
emigre937053emigre
emir65918703e_mir_
emirs76116163e_mirs
empale102611263empale
empery1348683empery
empiric1345963empiric
emprise11310723emprise
emprize2038843emprize
emptier1187603emptier
encore8314773encore
endite73817593endite
endive103310473endive
endure74014143endure
engine71114863engine
engird8126973engird
engirt71112613engirt
enquire16287213enquire
ensile62616473ensile
ensure63416003ensure
entice81316863entice
entires71517783entires
enure53520223e_nure
envier939673envier
enviro936303enviro
eosine64519413eosine
epee64628503e_p_ee
epic86921303e_pi_c
epics95014283e_pics
epicure1136823e_picure
epimer10109153e_pimer
epimere1186983e_pimere
epode85114093e_pode
equine151711573equine
ere36352773e___re
ermine8416923ermine
espial839543espial
espied9359773espied
espies83716803espies
esprit8312843esprit
esquire16376603esquire
etoile6312263etoile
euchre11137663euchre
euphroe1245393euphroe
evite85317683e_vite
examine161510033examine
exaptive2045253exaptive
excided1836203excided
excides1738343excides
excimer1834963excimer
exciple1874683exciple
excised1736673excised
excises1638933excises
excited1737853excited
exciter1637753exciter
excites16310633excites
excuse1537423excuse
exedra1434503exedra
exedrae1544713exedrae
exert124624143ex_ert
exhale1636873exhale
exhort16410803exhort
exhume1833803exhume
exiled144712463ex_iled
exiler134712183ex_iler
exiles134816403ex_iles
exines135715803ex_ines
exing136016813ex_ing
exist124618943ex_ist
exit114428673ex_i_t
exited144712523ex_ited
exits125515913ex_its
exospore1745233exospore
expand16236573expand
expanse16145603expanse
expat14313813exp_at
expats1537683expats
expect1758903expect
expedite1847263expedite
expel1448233exp_el
expels1547173expels
expend16247503expend
expense16127873expense
experted1838053experted
experts1659063experts
expiable1946113expiable
expiated18168523expiated
expiates17810213expiates
expiring1836253expiring
explode1745963explode
explored1845083explored
explorer1744713explorer
explores1746253explores
expo1349183exp__o
exported1837133exported
exporter1737363exporter
exports1647983exports
expos1449203exp_os
exposed1737443exposed
exposer1637413exposer
exposes1639963exposes
exposure1743673exposure
express1637493exp_ress
expulse1674513expulse
expunge1743313expunge
exsert13414363exsert
extern1348473extern
externe1438573externe
extort13513973extort
extra1239003ex_tra
exude134010293ex_ude
exurb1457703ex_urb
exuviae1744343exuviae
eyre75525253e__yre
eyrie88117833eyri_e
eyrir8359653eyrir_
fire76245593__fire
foxfire2042563foxfire
glaire74411293glaire
hempie132410563hempi_e
hempier14319003hempier
hire75538963__hire
impure1038383impure
inspire938253inspire
ire36943173___ire
kelpie12308613kelpi_e
kewpie15465413kewpi_e
lempira1144193lempira
lipide93511063lipide
lire47845293__lire
lupine84013533lupine
mire66748233__mire
moire71017323_moire
mopier103914783mopier
opine77422463_opine
orpine83914483orpine
oxide131210953ox_ide
oxime1498433ox_ime
oxlike17307473oxlike
pare66760843__pare
peppier10268323peppier
pere66450263__pere
perspire1246663perspire
pice84641093__pice
pie55457403__pi_e
pier66035293__pier
pike106335213__pike
pile65649693__pile
pine67755713__pine
pipe86434433__pipe
pipier104913983pipier
pirn67128373__pirn
pore66451263__pore
pure65543333__pure
pyre94925553__pyre
quire144917133_quire
rapier84019993rapier
rapine85023083rapine
refire95419473refire
rehire95415863rehire
repine85627813repine
require16148653require
respired1148993respired
respires10311903respires
respite9513033respite
retire64927013retire
rewire95421413rewire
rexine134719443rex_ine
ropier84118803ropier
satire63218003satire
seepier92912013seepier
sempre102710093semp_re
sexier13310683sex_ier
sextile1438573sextile
shire84727133_shire
sire46150413__sire
sopite84917713sopite
spare75135563_spare
spice95528813_spice
spier75728033_spier
spike114922843_spike
spile75230083_spile
spine76534423_spine
spirea84015633_spirea
spired94921863_spired
spirem104214163_spirem
spires84628113_spires
spirt75032953_spirt
spiry105017353_spiry
spite75430663_spite
spore75428593_spore
squire155912463squire
supine84216693supine
suspire937803suspire
tapir75917063tapir_
tapirs84113173tapirs
textile1437223textile
texture1497083texture
tire46143353__tire
typier1137333typier
umpired1235783umpired
umpires1137813umpires
unexpired1943283unexpired
unpile81914323unpile
unpure82911533unpure
uppile10178503uppile
vampire14296673vampire
venire93513693venire
vespine1237903vespine
weepie11258793weepi_e
weepier12319273weepier
wire75839813__wire
zaire14311993_zaire

Search took 10 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 Limit1127162688.97012565.9
3Display Results2682680.1861440.9
 (SQL Overall)1786912689.54618718.9
 
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.