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 “soldiering” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

41 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
soldiering124424(None) 
soldering1169031sold_ering
soldierings1352151soldierings
moldering1367862mold_ering
smoldering1474102smold_ering
soldieries1145592soldieries
bolstering1346883bolstering
bordering1338833bord_ering
bouldering1464763bould_ering
doddering1335183do_ddering
foddering1535163fo_ddering
hollering1337743hol_lering
holstering1447083holstering
mouldering1474283mould_ering
ordering1039353_ord_ering
pondering132411333pond_ering
powdering16246503powd_ering
resoldering1343993resold_ering
scowdering1743983scowd_ering
shouldering1662343should_ering
shuddering1643513shuddering
silvering1337923sil_vering
slavering1338723s_lavering
slivering1338083s_livering
slobbering15103883slobbering
smouldering1572173smould_ering
sobering111912783so__bering
soddening1244543so_ddening
soldier82812153soldier___
soldiered1143763soldier_ed
soldierly13222903soldier_ly
soldiers9277773soldier__s
soldiery12254613soldier__y
solferino1243873sol_ferino
solidifying1952793solidifying
sortieing1046163sortie_ing
spiering112713353s__piering
sundering11312323sund_ering
unsoldering1342673unsold_ering
wildering1456743wild_ering
wondering142110463wond_ering

Search took 7 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 Filter1786911406030.420425454.8
2DLD Change Limit140603415.62624991.6
3Display Results41410.0331242.4
 (SQL Overall)178691416.07929394.8
 
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.