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

116 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
suspired113561(None) 
suspire937801suspire_
suspires1038201suspires
aspired1068172_aspired
inspired1136272inspired
respired1148992respired
spired94921862__spired
supered10316122su_pered
umpired1235782_umpired
aspire8612123_aspire_
aspirer967903_aspirer
aspires9612043_aspires
auspice1136523auspice_
auspices1236443auspices
bumpered1536003bumpered
busied95117223bus_i_ed
buskined1534443buskined
conspired1445663conspired
cuspated1335913cuspated
cusped114312043cusp__ed
cuspid11429213cuspi__d
cuspides13306943cuspides
desired9311983des_ired
despaired1344503despaired
despised1236923despised
despited1248323despited
espied9359773_espi_ed
expired1736403_expired
gussied9267193gussi_ed
inspire938253inspire_
inspirer1045183inspirer
inspires1037623inspires
lustered92510603lustered
lustred8359053lus_tred
misfired14238543misfired
muspike1536043muspike_
muspikes1635243muspikes
mustered112511503mustered
outfired1238083outfired
perspired1444213perspired
quired163711953qu__ired
respire9411543respire_
respires10311903respires
respited11410813respited
sceptred1343653sceptred
scuppered1643933scuppered
shunpiked1941273shunpiked
simpered1338253simpered
sired66134283__s_ired
sistered92612803sistered
sopited104211063s_opited
spared95427493__spared
speired103811103s_peired
spiced115218313__spiced
spied85427713__spi_ed
spiered104412463__spiered
spiked134915553__spiked
spiled94621993__spiled
spined95423943__spined
spire75828693__spire_
spirea84015633__spirea
spirem104214163__spirem
spires84628113__spires
spirted103913073__spirted
spited94820443__spited
spored94821793__spored
squired173710063s_quired
sublimed1337213sublimed
subsided1257663subsided
subsoiled1245453subsoiled
succored13135173succored
suckered1537833suckered
suffered1536733suffered
sufficed17205663sufficed
suffixed22214343suffixed
sugared938583su_gared
suicided1246033suicided
suited74019423su__ited
sulfured1236113sulfured
sullied83714483sulli_ed
sulphured1542923sulphured
summered1338143summered
summited13246413summited
sumpweed1643723sumpweed
sunbird1044743sunbir_d
sundered10312153sundered
supine84216693su_pine_
supines94216383su_pines
supped114415703su_p_ped
suppled1248463su_ppled
supplied1345993supplied
supported1444683supported
supposed1345783supposed
surmised1136863surmised
surpliced1444153surpliced
surprised1245313surprised
surprized2144663surprized
survived1534073survived
suspected1444383suspected
suspend1036013susp_end
suspended13104513suspended
suspiring1245703suspiring
sussed75015533sus__sed
sustained1045383sustained
sutured8310373su_tured
umpire1047893_umpire_
umpires1137813_umpires
unaired82916013_unaired
unfired112212453_unfired
unhired112512153_unhired
unpaired11208943_unpaired
unpiled102312743_unpiled
untired82316383_untired
uppiled12216593_uppiled
upsized19246253_upsized
ushered1139153_ushered

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 Limit1461621166.54622328.4
3Display Results1161160.0462521.7
 (SQL Overall)1786911166.99825534.6
 
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.