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

149 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
expiring183625(None) 
aspiring1138872aspiring
exciding1935922exciding
excising1837212excising
exciting1838022exciting
exiling15311082ex_iling
exiting15311392ex_iting
experting1938052experting
expiating1938542expiating
expiries1747752expiries
exploring1945542exploring
exporting1937322exporting
exposing1836672exposing
respiring12159902respiring
spiring103918182_spiring
umpiring1336092umpiring
admiring1236133admiring
airing74927503__airing
aspirin937823aspirin_
aspirins1037733aspirins
attiring939483attiring
bemiring13239603bemiring
capering132414963capering
chairing143110773chairing
choiring14279793choiring
deairing10311893deairing
desiring10312143desiring
despairing1445063despairing
despising13167503despising
despiting13179323despiting
earing75235483e__aring
earring83519013e_arring
editing9313133e_diting
eliding93414343e_liding
eloining9310443eloining
emailing113010043emailing
empaling1338363empaling
empiric1345963empiri_c
empirics1444003empirics
emptying1634243emptying
encoring11312173encoring
enditing10311073enditing
enduring10310013enduring
engining1039293engining
engirding1244153engirding
enquiring19175443enquiring
ensiling9410723ensiling
ensuring9310173ensuring
entering91920053entering
enticing11311803enticing
enuring8813883e_nuring
erring73816483e__rring
espying1336193esp_ying
esquiring19174023esquiring
euchring1436613euchring
eviting11511373e_viting
exacting1838523exacting
exalting1638033exalting
examining1945143examining
excusing1836503excusing
exerting162211153exerting
exhaling1936293exhaling
exhorting2045733exhorting
exhuming2143303exhuming
exing136016813ex___ing
existing1639073existing
exocrine1745993exocrine
expanding2044793expanding
expecting2146693expecting
expediting2144643expediting
expelling1936133expelling
expending2045933expending
expensing1946003expensing
expire1538023expir__e
expired1736403expir_ed
expirer1635993expir_er
expirers1735123expirers
expires1638683expir_es
expiry1834653expir__y
explain1667043explain_
explaining2044303explaining
explains1766443explains
exploding2044933exploding
exploiting2044893exploiting
expositing2045353expositing
expulsing1944283expulsing
expunging2042833expunging
exserting1736663exserting
extorting1746763extorting
exuding16347443ex_uding
exulting1637643exulting
fairing113614013_fairing
firing104021723__firing
glairing1047283glairing
heiring113312903_heiring
hiring104421603__hiring
impairing1445473impairing
inspiring1246183inspiring
iring66025423___iring
lairing83715343_lairing
miring93723803__miring
opining10311743_opining
pairing103716733_pairing
papering132213313papering
paring94236493__paring
peppering1337083peppering
perspiring1544853perspiring
pieing93917653__pieing
piing85218833__pi_ing
piking133719643__piking
piling95025593__piling
pining93726533__pining
piping114017453__piping
poring94227273__poring
quiring17159993_quiring
refiring123513923refiring
rehiring122911883rehiring
repairing12310013repairing
repining114116593repining
requiring1937043requiring
respiting121912863respiting
respring111614063resp_ring
retiring92717413retiring
rewiring122911223rewiring
siring75128313__siring
sopiting11310763sopiting
sparing104823873_sparing
speiring113711263speiring
spicing123914533_spicing
spiering112713353_spiering
spiking144312883_spiking
spiling102919703_spiling
spirting112913633_spirting
spiting103917623_spiting
sporing104319413_sporing
spring94526013_sp_ring
squiring18177563squiring
supering11317683supering
suspiring1245703suspiring
tapering112112503tapering
tempering1438733tempering
texturing1735223texturing
tiring74023093__tiring
unpiling1139753unpiling
untiring9312003untiring
uppiling1335853uppiling
vaporing1437653vaporing
wairing113414313_wairing
wiring104521023__wiring

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621496.56322270.6
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.03225411.1
 
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.