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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

142 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
unhatting133587(None) 
chatting142810142_chatting
hatting113920232__hatting
unfitting1336422unfitting
unhairing1335952unhairing
unhanding1437202unhanding
unhanging1436362unhanging
unsetting1088992unsetting
unstating10711212unstating
unwitting1335582unwitting
batting104422273__batting
blatting114111653_blatting
catting103922643__catting
chanting143413533_chanting
charting142614193_charting
defatting1436103defatting
deratting1139513deratting
dratting10389663_dratting
enacting11311363en_acting
enchanting1645943enchanting
enhaloing1345363enhaloing
enhancing1545823enhancing
fatting113818703__fatting
flatting123511253_flatting
hafting144014173__hafting
halting114419073__halting
hanting114124483__hanting
hasting114725193__hasting
hating104929713__ha_ting
hitting113017273__hitting
hotting113116523__hotting
hutting113016033__hutting
incanting1289903incanting
inhabiting1644293inhabiting
inhaling1239523inha_ling
inletting1087873inletting
inputting1235823inputting
insetting1079283insetting
instating10812213instating
knitting13257023kn_itting
knotting13236573kn_otting
matting103620143__matting
netting84018763_n_etting
notating92513343_notating
nutating92411953nuta_ting
nutting83316233_n_utting
outhitting1446333outhitting
patting103722343__patting
platting114813033_platting
ratting83822363__ratting
scatting113311813_scatting
shafting15278683_shafting
shitting123212663_shitting
shotting123012383_shotting
shutting12309693_shutting
slatting94014233_slatting
spatting113111763_spatting
splatting1235983splatting
squatting1934513squatting
sunbathing1642933sunbathing
swatting12309593_swatting
tatting84019523__tatting
umlauting1243163umlauting
unabating1246753unabating
unageing1036273un_ageing
unaging9510933un_a_ging
unarming1138623un_arming
unbaling11310683unba_ling
unbanning1235893unbanning
unbarring1236063unbarring
unbelting1237663unbelting
unbolting1236453unbolting
unbottling1343133unbottling
uncaging1268713unca_ging
uncaking1539463unca_king
uncapping1635133uncapping
uncaring11312843unca_ring
uncasing11511003unca_sing
unchaining1645693unchaining
unchairing1644603unchairing
unchanging1745223unchanging
uncharging1744393uncharging
uncharming1844523uncharming
uncoating12611923uncoating
uncrating12813183uncrating
undaring10412753unda_ring
unearthing1454373unearthing
unfading1347693unfa_ding
unfailing1337453unfailing
ungazing1936033unga_zing
unhang1038443unha___ng
unhatted1238183unhatt_ed
unheeding1446103unheeding
unhelming1535493unhelming
unhinging1436093unhinging
unhitching1942843unhitching
unhooding1435893unhooding
unhooking1735353unhooking
unhorsing1336853unhorsing
unhousing1335883unhousing
unhusking1744093unhusking
uniting8315823un__iting
unjamming2143043unjamming
unknitting1542873unknitting
unknotting1542663unknotting
unlacing1148653unla_cing
unlading1058863unla_ding
unlashing1336493unlashing
unlatching1643153unlatching
unlaying1258363unla_ying
unmaking1538133unma_king
unmanning1245873unmanning
unmasking1635263unmasking
unmitring1245263unmitring
unnailing1037023unnailing
unpacking1835133unpacking
unpaying1456943unpa_ying
unpitying1544043unpitying
unplaiting1345503unplaiting
unquoting1944763unquoting
unresting10311133unresting
unrooting1098833unrooting
unsaying1288153unsa_ying
unseating10713203unseating
unsettling1144433unsettling
unsheathing1892983unsheathing
unshifting1743863unshifting
unstring9312093un_string
unswathing1743303unswathing
untacking1636643untacking
untying1138943un__tying
unvarying1644503unvarying
unwaning1238133unwa_ning
unweeting1336473unweeting
upcasting1434823upcasting
updarting1334333updarting
updating1236593upda_ting
uprating11311113upra_ting
upsetting1275563upsetting
upwafting1842063upwafting
vatting113614853__vatting
whetting1535973_whetting

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 Filter1786911486410.406440125.6
2DLD Change Limit1486411426.36023371.2
3Display Results1421420.0632254.0
 (SQL Overall)1786911426.82926166.5
 
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.