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

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

84 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
unthreatening1711125(None) 
nonthreatening1861082nonthreatening
threatening1543062__threatening
unthreading1644153unthrea__ding
entreating11811554ent_reat__ing
greatening1245444___greatening
intreating11614014int_reat__ing
neatening1038354_n___eatening
threateningly2061214__threateningly
threating131010044__threat__ing
uncreating13310474un_creat__ing
undereating1369554undereat__ing
unpretending1672834un_pre_tending
unreasoning1242974un__reasoning
unsheathing1892984unsh_eat_hing
unthroning1445494unthr___oning
untreading1247564unt_rea__ding
unwreathing1842804un_wreat_hing
cheapening1883805__ch_eapening
christening1743405__christening
contravening1853565cont_r_avening
disheartening1852385dish_eartening
ensheathing18102565ensh_eat_hing
entertaining1354385enterta_ining
enthralling1543845enthr_a_lling
enthroning1446035enthr___oning
entraining1147645ent_r_a_ining
enwreathing1842125en_wreat_hing
estreating11710365est_reat__ing
heartening1446735___h_eartening
inbreathing1742805in_breat_hing
insheathing18102695insh_eat_hing
interesting12411125interest__ing
interlayering1753055interlayering
intermatting1547175intermat_ting
intervening1548175int__ervening
inthralling1544115inthr_a_lling
inthroning1446225inthr___oning
outbrazening2461425outbr_azening
outpreening1444195outpre__ening
outreasoning1352135out_reasoning
rechristening1961395rechristening
rethreading16154285rethrea__ding
retreating111414775ret_reat__ing
straitening1243665_st_raitening
sunscreening1551445sunscre__ening
threading14107595__threa__ding
threaping15106115__threa__ping
threaten1146305__threate__n_
threatened1442775__threaten_ed
threatener1342935__threaten_er
threateners1452815__threateners
threatens1254665__threate__ns
threeping15104805__thre__eping
throating1398395__throat__ing
treating92519615__t_reat__ing
unburdening1552015unbur__dening
unchaining1645695unch__a_ining
uncrating12813185un_cr_at__ing
undereaten1149545undereate__n_
underheating1785135underheat__ing
underrating1388255underrat__ing
unfastening1572785un__fastening
unfettering1543705un__fettering
unfreeing1345105un_fre__e_ing
unfreezing2343345un_fre__ezing
unhatting1335875un_h__at_ting
unheeding1446105un_h_e__eding
unlearning1144715un__lea_rning
unmeaning1237955un__mea__ning
unraveling1454475un__r_aveling
unreeling1038985un__re__eling
unreeving1336215un__re__eving
unrelenting1244425un__re_lenting
unresting10311135un__rest__ing
unretiring1145305un__re_tiring
unseating10713205un__seat__ing
unteaching1645495unt__ea_ching
untethering1543685unt__ethering
unthreaded1543535unthreade___d
untracking1746935unt_r_a_cking
untreated10312905unt_reate___d
untrusting1186005unt_rust__ing
upthrusting1751405upthrust__ing

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 Filter1786911247900.1431249587.4
2DLD Change Limit124790848.09315419.5
3Display Results84840.0461826.1
 (SQL Overall)178691848.28221575.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.