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

119 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
experting193805(None) 
exerting162211151ex_erting
expecting2146691expecting
exporting1937321exporting
exserting1736661exserting
everting122213132e_verting
excepting2145872excepting
excerpting2244142excerpting
excreting1946432excreting
exhorting2045732exhorting
expediting2144642expediting
expelling1936132expelling
expending2045932expending
expensing1946002expensing
expertise1847932expertise
expertism2045432expertism
expertize2746582expertize
expertizing3044622expertizing
expiating1938542expiating
expiring1836252expir_ing
exsecting1935932exsecting
extorting1746762extorting
adverting1437223adverting
alerting91312383_alerting
asperating1349563asperating
aspersing1237603aspersing
asserting1038663asserting
averting122512733_averting
capering132414963caper_ing
coexerting2045493coex_erting
departing1349513departing
deperming1537113deperming
deporting1369593deporting
deserting11713143deserting
diverting142410333diverting
effecting1845583effecting
egesting1039013e_gesting
ejecting18268163e_jecting
electing112113783e_lecting
emerging1237893e_merging
enserfing1345893enserfing
entering91920053enter_ing
erecting112415063e_recting
escorting1237713escorting
exacting1838523ex_acting
exalting1638033ex_alting
exasperating2253183exasperating
exceeding2043493exceeding
excelling1935643excelling
excessing1945713excessing
exciting1838023ex_citing
execrating2047883execrating
executing1945583executing
exempting2144223exempting
exertion15310083ex_ertion
exertions1639763ex_ertions
exertive1839083ex_ertive
existing1639073ex_isting
exiting15311393ex__iting
exonerating1945553exonerating
expanding2044793expanding
expectant2045673expectant
expert15515353expert___
experted1838053expert_ed
expertises1947103expertises
expertisms21114493expertisms
expertized2944713expertized
expertizes28106013expertizes
expertly2044703expert_ly
experts1659063expert__s
explanting2045223explanting
exploding2044933exploding
exploiting2044893exploiting
exploring1945543exploring
exposing1836673exp_osing
expositing2045353expositing
expressing2046623expressing
expulsing1944283expulsing
expunging2042833expunging
expurgating2243283expurgating
exsertile1644593exsertile
exsertion1646853exsertion
exsertions1746743exsertions
extending1835853extending
extermine1848283extermine
exuberating2144173exuberating
exulting1637643ex_ulting
imparting1437243imparting
importing1438193importing
inserting10914243inserting
inverting131013223inverting
obverting1536303obverting
operating12313723_operating
papering132213313paper_ing
parting103527383__parting
pelting102917273__pelting
peppering1337083pepper_ing
perking143716463__perking
perming123416093__perming
perverting1646623perverting
petting103720953__petting
pipetting1435513pipetting
porting103021783__porting
reexporting2143423reexporting
reoperating1449023reoperating
repeating122618983repeating
repenting122316553repenting
reperking1638703reperking
reporting12513903reporting
respecting1549883respecting
reverting132315133reverting
spirting112913633_spirting
sporting112415463_sporting
spurting113111633_spurting
supering11317683super_ing
tapering112112503taper_ing
tempering1438733temper_ing
tempesting1544453tempesting
vespertine1544663vespertine

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411197.73319221.6
3Display Results1191190.0631888.9
 (SQL Overall)1786911198.21921741.2
 
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.