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

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

147 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
twits8601579(None) 
tits46145051t_its
toits55327471toits
twats86616601twats
twigs96911171twigs
twins85118981twins
twist86820981twist
twists9549751twists
twit76329061twit_
wits76044881_wits
adits66523712adits
aits46355542_aits
awaits96411952awaits
baits76630582baits
bits66148172_bits
brits76433082brits
chits105424572chits
crits75527572crits
dits56450532_dits
doits66223672doits
duits65021882duits
edits65819032edits
emits75421472emits
exits125515912exits
fits76043472_fits
flits85625222flits
frits86129102frits
gaits65726012gaits
gits55744602_gits
grits65529582grits
hits75545142_hits
its35538842__its
iwis77117012iwi_s
kits86441782_kits
knits93914752knits
lits46252502_lits
nits45741652_nits
nitwits1035052nitwits
obits74617552obits
omits75018262omits
outwits103110862outwits
pewits112810682pewits
pits66348752_pits
quits144122352quits
shits84731172shits
sits45050212_sits
skits94721872skits
slits56128852slits
snits54124832snits
spits74429552spits
suits55028052suits
swats85726862swats
swifts12408172swifts
swigs96213662swigs
swims105514142swims
swiss86712902swiss
swith115917402swith
swots85518432swots
tacts76524122tacts
tails55634192tails
tains54936322tains
taints64520532taints
tarts57242022tarts
tats46858132t_ats
tauts56125512tauts
teats55636812teats
tents56434212tents
tests56530192tests
tets45847462t_ets
texts125515042texts
thins85826332thins
this76027382thi_s
tics65729642t_ics
ties45248322t_ies
tils45739622t_ils
tilts55325612tilts
tins45251312t_ins
tints56030922tints
tips66436772t_ips
tis37056652t_i_s
tit36771062t_it_
titi47130632t_iti
titis56023812t_itis
tofts84919242tofts
toils54527492toils
toit46353062toit_
toots55331872toots
torts56138122torts
tots46654122t_ots
touts54830392touts
towies93521192towies
traits65121982traits
trets55928022trets
tries55742812tries
trigs65423062trigs
trims75021472trims
trios55528092trios
trips74923362trips
trite54730032trite
trots56629942trots
tufts85713272tufts
tuis44829642tui_s
tuts45838452t_uts
twaes86513662twaes
twains95811182twains
twas76824082tw_as
twat75831512twat_
tweets94210102tweets
twice104711122twice
twier84713292twier
twiers95410162twiers
twig87615772twi_g
twill85612722twill
twills9489792twills
twin76023082twi_n
twine85822362twine
twines94717272twines
twiny116012812twiny
twirl85011942twirl
twirls9478122twirls
twirp10468942twirp
twirps11415012twirps
twisty12426862twisty
twitch14406162twitch
twixt155512482twixt
twos76718022tw_os
units54923432units
unwits9389892unwits
waits88333522waits
wats77555882_wats
wets75940292_wets
whits115923822whits
wigs84931262_wigs
wilts85023502_wilts
wins75949182_wins
wis66552342_wi_s
wiss75630552_wiss
wist78049302_wist
wists86728522_wists
wit66563782_wit_
wite75443282_wite
wites85536962_wites
with105730482_with
wots76342892_wots
writs86624382writs
ywis105313102ywi_s
zits136030302_zits

Search took 3 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 Filter178691538000.330541487.9
2DLD Change Limit538001471.75030742.9
3Display Results1471470.0463195.7
 (SQL Overall)1786911472.12684050.3
 
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.