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

262 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
expires163868(None) 
empires1139851empires
expire1538021expire_
expired1736401expired
expirer1635991expirer
expirers1735121expirers
expiries1747751expiries
aspires9612042aspires
empire1039322empire_
entires71517782entires
espies83716802espi_es
excides1738342excides
excises1638932excises
excites16310632excites
exiles134816402ex_iles
exines135715802ex_ines
experts1659062experts
expiates17810212expiates
expiry1834652expir_y
explores1746252explores
exports1647982exports
exposes1639962exposes
express1637492exp_ress
respires10311902respires
spires84628112_spires
umpires1137812umpires
admires1038663admires
alpines94016193alpines
amperes11313983amperes
apices104916263_apices
apres75426403_ap_res
aspire8612123aspire_
aspired1068173aspired
aspirer967903aspirer
aspirers1066493aspirers
aspises9611643aspises
attires72312953attires
axises134413993ax_ises
axites134913833ax_ites
bemires113212833bemires
capizes20410373capizes
cires74932913__cires
copiers114215963copiers
copies104130303copi_es
cypres1338523cyp_res
desires81316133desires
despises1139433despises
despites11410313despites
dexies145018343dex_i_es
eagres74014573e_agres
easies64126633easi_es
eddies83313163eddi_es
ediles74016973e_diles
egises7312493e_gises
elides74420693e_lides
elites66027123e_lites
emeries91620023emeries
emigres1037673emigres
emirs76116163e_mir_s
empales112411433empales
emperies12314563emperies
empiric1345963empiric
empirics1444003empirics
empress1138163emp_ress
emprise11310723emprise
emprises12311003emprises
emprizes2138133emprizes
emptiers1275193emptiers
empties11712243empties
encores9315213encores
endites83717063endites
endives113710693endives
endures83314603endures
engines81114463engines
engirds995053engirds
enquires17276973enquires
ensiles72714833ensiles
ensures73315903ensures
entices91616333entices
entire61617703entire_
entries71523163entries
enures63919713e_nures
enviers1036993enviers
envies9314053envi_es
enviros1034913enviros
eosines73718293eosines
epees75219833e_p_ees
epics95014283e_pi_cs
epicures1246513e_picures
epimer10109153e_pimer
epimeres12117653e_pimeres
epimers11109493e_pimers
epodes94315563e_podes
eposes84418783e_poses
equines161811593equines
equites162212493equites
ermines9416663ermines
espials937093espials
espied9359773espi_ed
esprits938393esprits
esquires17266203esquires
etoiles7411293etoiles
euchres1288663euchres
euphroes1345993euphroes
evites94916473e_vites
examines17128773examines
excide1638423excide_
excided1836203excided
excimer1834963excimer
excimers1944703excimers
exciples1964763exciples
excise1538553excise_
excised1736673excised
excite15310883excite_
excited1737853excited
exciter1637753exciter
exciters1736323exciters
excuses1638903excuses
exerts133712293ex_erts
exes116530813ex___es
exhales1737143exhales
exhorts1746313exhorts
exhumes1934323exhumes
exile126117653ex_ile_
exiled144712463ex_iled
exiler134712183ex_iler
exilers14419733ex_ilers
exine125518493ex_ine_
exists134710913ex_ists
exited144712523ex_ited
exits125515913ex_i_ts
exospores1845473exospores
expands17195733expands
expanse16145603expanse
expanses17156173expanses
expats1537683exp_ats
expects1866883expects
expedites1946163expedites
expel1448233exp__el
expels1547173exp_els
expends17217083expends
expense16127873expense
expenses17138373expenses
expert15515353exper_t
experted1838053experted
expiate16910593expiate
expiated18168523expiated
expiring1836253expiring
explodes1845803explodes
explore1646613explore_
explored1845073explored
explorer1744713explorer
explorers1843743explorers
export15412183expor_t
exported1837133exported
exporter1737363exporter
exporters1846253exporters
expos1449203exp__os
expose1549523expose_
exposed1737443exposed
exposer1637413exposer
exposers1736133exposers
exposures1843483exposures
expresso1743883exp_resso
expulse1674513expulse
expulses1774813expulses
expunges1843573expunges
exserts1467013exserts
externes1539823externes
externs1438233externs
extorts1447753extorts
extras13310223ex_tras
exudes143710363ex_udes
exurbs1534423ex_urbs
eyres84921773e__yres
eyries93816813eyri_es
fires85740753__fires
foxfires2142813foxfires
glaires84010133glaires
hires86134343__hires
inspires1037623inspires
ires45639283___ires
kelpies13289903kelpi_es
kewpies16246923kewpi_es
lapides103012043lapides
lapises93513463lapises
lempiras1243853lempiras
lipides103810623lipides
lupines93912503lupines
mires75640883__mires
moires8915633_moires
opines84820703_opines
orpines94414793orpines
oxides14109693ox_ides
oximes15107423ox_imes
pares77164483__pares
peres76246643__peres
perspires1346663perspires
piers75926333__piers
pies66949603__pi_es
pikes115031033__pikes
piles74742613__piles
pines76048863__pines
pipes96030143__pipes
pirns76020093__pirns
pixes144323173__pixes
pores75849033__pores
pries74339533__pries
pyres105523883__pyres
quires154015733_quires
rapiers95012873rapiers
rapines95120863rapines
refires104820313refires
rehires105016113rehires
repines94927383repines
requires17168703requires
respire9411543respire_
respired1148993respired
respites10513243respites
retires74726213retires
rewires104717113rewires
rexines144719153rex_ines
satires72617573satires
sextiles1537643sextiles
shires95225573_shires
sires55945373__sires
sopites93817173sopites
spares84834553_spares
spices104326033_spices
spiers84421743_spiers
spies76037623_spi_es
spikes124520713_spikes
spiles84227913_spiles
spines85132033_spines
spire75828693_spire_
spirea84015633_spirea
spireas94412513_spireas
spired94921863_spired
spirem104214163_spirem
spirems11499563_spirems
spirts85317133_spirts
spites84127333_spites
spores84726613_spores
squires163812833squires
supines94216383supines
suspires1038203suspires
tapirs84113173tapir_s
tapises92914013tapises
textiles1536833textiles
textures1597523textures
tires55437493__tires
umpire1047893umpire_
umpired1235783umpired
unexpired1943283unexpired
unpiles92112783unpiles
uppiles11208263uppiles
vampires15226033vampires
venires103012453venires
vires84529683__vires
weepies122811743weepi_es
wires86034913__wires
zaires1539703_zaires

Search took 9 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.1561145455.1
2DLD Change Limit1340272628.32616097.4
3Display Results2622620.2031290.6
 (SQL Overall)1786912628.68520574.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.