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

134 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
unfitting133642(None) 
unwitting1335581unwitting
befitting15236622befitting
fitting113516562__fitting
knitting13257022kn_itting
outfitting1465822outfitting
refitting132811122refitting
unfixing1935682unfi_xing
unhatting1335872unhatting
uniting8315822un_i_ting
unknitting1542872unknitting
unmitring1245262unmitring
unpitying1544042unpitying
unsetting1088992unsetting
admitting1345033admitting
anointing1038623anointing
benefitting1752853benefitting
bitting103717293__bitting
defatting1436103defatting
demitting13239073demitting
emitting112410353_emitting
enditing10311073endi_ting
enlisting1038343enlisting
entitling1037103entitling
fatting113818703__fatting
fetting113517873__fetting
fisting113818123__fisting
fittings12318203__fittings
flitting123010883_flitting
fritting123510703_fritting
gitting93215703__gitting
gritting10309983_gritting
gunfighting2051773gunfighting
hitting113017273__hitting
inciting11312533inci_ting
indicting1339613indicting
inditing10312113indi_ting
infecting15109673infecting
infesting13109513infesting
infighting1844413infighting
infirming1545163infirming
infixing1936103infi_xing
inflating13310443inflating
inflicting1645723inflicting
inletting1087873inletting
inputting1235823inputting
insetting1079283insetting
insisting1038823insisting
intitling1037213intitling
inviting1239733invi_ting
kitting123214443__kitting
knittings14273453kn_ittings
knotting13236573kn_otting
misfitting1645533misfitting
netting84018763_n_etting
nutting83316233_n_utting
omitting11217743_omitting
outhitting1446333outhitting
outsitting1147133outsitting
outwitting1445553outwitting
pitting103618873__pitting
quitting18228833_quitting
remitting122412623remitting
resitting103414873resitting
shitting123212663_shitting
sitting83519633__sitting
slitting93012583_slitting
spitting113012323_spitting
splitting1236563splitting
submitting1544973submitting
twitting12307223_twitting
unabating1246753unabating
unbelting1237663unbelting
unbinding1336513unbinding
unbitten1045213unbitten_
unbolting1236453unbolting
unbottling1343133unbottling
uncoating12611923uncoating
uncrating12813183uncrating
unfading1347693unf_ading
unfailing1337453unfailing
unfearing1338883unfearing
unfeeling1337113unfeeling
unfencing1545953unfencing
unfettering1543703unfettering
unfitted1238163unfitt_ed
unfolding1436063unfolding
unfreeing1345103unfreeing
unfurling1335763unfurling
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
untidying1445473untidying
untieing938863unti_eing
untiring9312003unti_ring
untwisting1443943untwisting
untying1138943un__tying
unweeting1336473unweeting
unwilling1337163unwilling
unwinding1435843unwinding
unwinking1735073unwinking
unwishing1635593unwishing
unwittingly1852773unwittingly
unzipping2342703unzipping
uplifting1534963uplifting
upsetting1275563upsetting
uptilting1234713uptilting
witting113417063__witting

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.640279204.7
2DLD Change Limit1486411345.98624831.4
3Display Results1341340.0602233.3
 (SQL Overall)1786911346.68626726.1
 
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.