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

47 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
fumigating174465(None) 
fulminating1744682fulminating
fumigation1645622fumigation
fumigations1744922fumigations
fustigating1654052fustigating
ruminating1348142ruminating
acuminating1645803acuminating
culminating1645733culminating
cumulating1546353cumulating
dominating1449403dominating
emigrating1467503_emigrating
fighting162710083f__ighting
filiating1339253fili_ating
fixating1936183f__ixating
flighting1736103f_lighting
foliating1339253foli_ating
freighting1844543freighting
frighting1736023f_righting
fumigant1444263fumiga__nt
fumigate1446153fumigat__e
fumigated1644723fumigat_ed
fumigates1545573fumigat_es
fumigator1543923fumigat_or
fumigators1643793fumigators
furcating1537783fu_rcating
geminating1447763geminating
humiliating1744083humiliating
imitating1238763_imitating
immigrating1743313immigrating
irrigating1245953irrigating
jubilating2045233jubilating
laminating1348733laminating
levigating1545693levigating
ligating102212283__ligating
litigating1246743litigating
migrating13910533__migrating
mitigating1447433mitigating
mutilating1349083mutilating
navigating1545003navigating
nominating1349503nominating
numerating1357233numerating
obligating1445813obligating
remigrating1547593remigrating
ruinating1039593ru_inating
summating1437943sum_mating
supinating1357833supinating
urinating10310653_urinating

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 Filter1786911406030.860207780.2
2DLD Change Limit140603477.34319147.9
3Display Results47470.0331424.2
 (SQL Overall)178691478.23621696.3
 
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.