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

51 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
irritating114629(None) 
irrigating1245951irrigating
imitating1238762i_mitating
irritatingly1652022irritatingly
irritation1048972irritation
irritations1147832irritations
irritative1345202irritative
agitating1138863_agitating
arbitrating1444793arbitrating
arrogating121778393arrogating
cavitating1646913cavitating
cogitating1447213cogitating
corotating1349323corotating
crepitating1645803crepitating
eructating1345693eructating
fritting123510703_frit_ting
gravitating1644003gravitating
gritting10309983_grit_ting
hesitating1448003hesitating
imbricating1844523imbricating
indicating1449693indicating
initiating1149623i_nitiating
instating10812213i_nstating
intimating13410823intimating
iodinating1246963iodinating
irradiating1353773irradiating
irrigation1147803irrigation
irrigations1246943irrigations
irritant847693irrita__nt
irritate867873irritat__e
irritated1076133irritat_ed
irritates977223irritat_es
irritator945223irritat_or
irritators1045133irritators
irrupting1243553irr_upting
lariating10311793lari_ating
levitating1446653levitating
marinating13410273marinating
meditating1448123meditating
militating1348823militating
nictitating1444383nictitating
nonirritating1472513nonirritating
restating102319413_restating
rotating92614553__rotating
ruinating1039593_ruinating
sanitating1149653sanitating
seriating10916403seri_ating
striating10914193stri_ating
urinating10310653_urinating
urticating1347353urticating
variating13310953vari_ating

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.406440125.6
2DLD Change Limit140603516.45321788.8
3Display Results51510.0331545.5
 (SQL Overall)178691516.89225927.3
 
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.