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

60 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
tormenting134569(None) 
commenting1749172commenting
fermenting1646822fermenting
fomenting1537232fo_menting
garmenting1445482garmenting
orienting1038722_orienting
tormentil1144222tormenti_l
tormentils1243772tormentils
alimenting1344503alimenting
augmenting1443853augmenting
cementing1438763_cementing
commencing1946183commencing
commending1846633commending
consenting13313213consenting
contenting13313323contenting
conventing16311543conventing
correcting15199303correcting
corseting12312173corse_ting
dementing13311043_dementing
documenting1753123documenting
foresting13311363for_esting
forfeiting1744133forfeiting
forfending1844183forfending
forgetting1544663forgetting
formatting1644163formatting
lamenting1237693_lamenting
margenting1446153margenting
mordanting1444003mordanting
nonmeeting1346073nonmeeting
omening10310093_o_men_ing
ornamenting1452563_ornamenting
parenting12611583par_enting
permeating1539923permeating
pigmenting1653713pigmenting
portending1446193portending
renting84026853__r_enting
reorienting1246353reorienting
rerenting102617663rer_enting
segmenting1445003segmenting
targeting1137303targe_ting
tenting84621153t___enting
terminating1447353terminating
threating131010053thr_eating
toileting1036263toile_ting
tokening1336463to_ken_ing
torment9316173torment___
tormented1245963torment_ed
tormenter1146703torment_er
tormenters1245823tormenters
tormentor1144363torment_or
tormentors1244173tormentors
torments10310453torment__s
torpedoing1442383torpedoing
torrefying1742853torrefying
torrential1054483torrential
treating92519613t_r_eating
trending103012833t_r_ending
truanting1035603t_ruanting
turpentine1253883turpentine
worsening1345553worsen_ing

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 Limit140603606.36022107.4
3Display Results60600.0601000.0
 (SQL Overall)178691606.82626178.0
 
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.