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

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

32 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
outreckoning195140(None) 
outreasoning1352132outreasoning
misreckoning2151913misreckoning
outechoing1644623out_echo_ing
outreckon1552373outrecko__n_
outreckoned1851523outreckon_ed
outreckons1652183outrecko__ns
outrocking1747053outrock__ing
reckoning1637643___reckoning
beckoning1845774___beckoning
outcooking1745524out__cooking
outcrowing1645994out__crowing
outdesigning1551534outdesigning
outearning1146744out_e_arning
outjockeying295644outjockeying
outkicking1644684outkick__ing
outlearning1243544outle_arning
outpreening1444194outpre__ening
outracing12912164outrac___ing
outranking1537674outrank__ing
outreaching1744914outre_aching
outreading1239284outre__ading
outrebounding1751094outrebounding
outrooting1147934outr__ooting
outrowing1339034outr___owing
outrunning1145684outr__unning
outscooping1643194out_scooping
outscoring1346234out_sc_oring
outscorning1443474out_scorning
outtricking1844144outtrick__ing
reckonings1742714___reckonings
unreasoning1242974_unreasoning

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 Filter1786911247900.390458182.1
2DLD Change Limit124790326.93617991.6
3Display Results32320.0162000.0
 (SQL Overall)178691327.34224338.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.