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

133 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
unwitting133558(None) 
unfitting1336421unfitting
knitting13257022kn_itting
outwitting1445552outwitting
twitting12307222_twitting
unhatting1335872unhatting
uniting8315822un_i_ting
unknitting1542872unknitting
unmitring1245262unmitring
unpitying1544042unpitying
unsetting1088992unsetting
untwisting1443942untwisting
unweeting1336472unweeting
unwilling1337162unwilling
unwinding1435842unwinding
unwinking1735072unwinking
unwishing1635592unwishing
unwittingly1852772unwittingly
witting113417062__witting
admitting1345033admitting
anointing1038623anointing
befitting15236623befitting
bitting103717293__bitting
demitting13239073demitting
emitting112410353_emitting
enditing10311073endi_ting
enlisting1038343enlisting
entitling1037103entitling
entwisting1443853entwisting
enwinding1444933enwinding
fitting113516563__fitting
flitting123010883_flitting
fritting123510703_fritting
gitting93215703__gitting
gritting10309983_gritting
hitting113017273__hitting
inciting11312533inci_ting
indicting1339613indicting
inditing10312113indi_ting
inletting1087873inletting
inputting1235823inputting
insetting1079283insetting
insisting1038823insisting
intitling1037213intitling
intwisting1445063intwisting
inviting1239733invi_ting
inwinding1445173inwinding
kitting123214443__kitting
knittings14273453kn_ittings
knotting13236573kn_otting
netting84018763_n_etting
nutting83316233_n_utting
omitting11217743_omitting
outfitting1465823outfitting
outhitting1446333outhitting
outsitting1147133outsitting
pitting103618873__pitting
quitting18228833_quitting
refitting132811123refitting
remitting122412623remitting
resitting103414873resitting
rewetting132710443rewetting
shitting123212663_shitting
sitting83519633__sitting
slitting93012583_slitting
spitting113012323_spitting
splitting1236563splitting
submitting1544973submitting
swatting12309593_swatting
swotting12268483_swotting
twisting12427813_twisting
unabating1246753unabating
unbelting1237663unbelting
unbinding1336513unbinding
unbitten1045213unbitten_
unbolting1236453unbolting
unbottling1343133unbottling
uncoating12611923uncoating
uncrating12813183uncrating
unfixing1935683unfi_xing
ungirding1245153ungirding
ungiving1346333ungi_ving
unhinging1436093unhinging
unhitching1942843unhitching
unifying1537553un_ifying
unitizing1947803un_itizing
unjointing1843963unjointing
unkinking1334783unkinking
unknotting1542663unknotting
unlinking1436273unlinking
unliving1248193unli_ving
unmitering1345003unmitering
unmixing1835543unmi_xing
unpicking1834883unpicking
unpiling1139753unpi_ling
unpinning1245623unpinning
unquoting1944763unquoting
unremitting1443213unremitting
unresting10311133unresting
unrigging1245183unrigging
unripping1434643unripping
unrooting1098833unrooting
unseating10713203unseating
unsettling1144433unsettling
unshifting1743863unshifting
unsighting1584443unsighting
unstating10711213unstating
unstinting1147303unstinting
unstring9312093un_string
unswathing1743303unswathing
untidying1445473untidying
untieing938863unti_eing
untiring9312003unti_ring
untwining1346303untwi_ning
untying1138943un__tying
unwaning1238133unw_aning
unweaving1636133unweaving
unweighting1952303unweighting
unwitted1237543unwitt_ed
unwritten1243143unwritten_
unzipping2342703unzipping
uplifting1534963uplifting
upsetting1275563upsetting
uptilting1234713uptilting
upwafting1842063upwafting
wetting114117383__wetting
wilting113515913__wilting
wisting113519743__wisting
withing143814493__withing
witing103522823__wi_ting
witling113215813__witling
wittings12328733__wittings
wotting112913843__wotting

Search took 8 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.436409841.7
2DLD Change Limit1486411336.89321564.1
3Display Results1331330.0602216.7
 (SQL Overall)1786911337.38924183.4
 
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.