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

132 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
units5492343(None) 
knits93914741knits
nits45741641_nits
snits54124831snits
unfits93910291unfits
unit45140071unit_
unite54828381unite
unites65024851unites
unity84918491unity
unwits9389891unwits
adits66523712adits
aits46355532_aits
anils56326722anils
anis45746462ani_s
antis55033312antis
ants47243472an_ts
audits72814112audits
aunts55227632aun_ts
baits76630582baits
binits85716672binits
bints76130182bints
bits66148162_bits
brits76433082brits
bundts95010842bundts
bunts75729802bun_ts
chits105424572chits
crits75527572crits
cubits103714032cubits
cunts76125122cun_ts
dints67431312dints
dits56450522_dits
doits66223672doits
duits65021882duits
dunite7315012dunite
dunites8313592dunites
dunts65828412dun_ts
edits65819032edits
emits75421472emits
exits125515912exits
fits76043462_fits
flits85625222flits
frits86129102frits
gaits65726012gaits
gits55744592_gits
gnats65217712gnats
grits65529582grits
gunite7414402gunite
gunites8313122gunites
hints87330622hints
hits75545132_hits
hunts86826172hun_ts
intis55121642intis
its35538832__its
kits86441772_kits
knit85728142knit_
knots95614722knots
lints57137192lints
lits46252492_lits
lunets66914762lunets
lunies64723012lunies
lunts55826902lun_ts
mints76834042mints
munis75022002muni_s
nets45941532_nets
nibs65028312_nibs
nils46132452_nils
nims66226882_nims
nips65830922_nips
nit37065942_nit_
nite45943582_nite
nites55736342_nites
nuts45032672_nuts
obits74617552obits
omits75018262omits
pints75936222pints
pits66348742_pits
pundits10379292pundits
punts75828002pun_ts
qubits173710352qubits
quints154316562quints
quits144122352quits
quoits15379682quoits
runts55927632run_ts
shits84731172shits
sits45050202_sits
skits94721862skits
slits56128852slits
snibs75613762snibs
snips75818012snips
snit46342472snit_
snots55225122snots
spits74429552spits
suints64617782suints
suits55028052suits
tints56030922tints
tits46145042_tits
toits55327472toits
tunics83811262tunics
twits86015792twits
unais53420772unais
unaus53216572unaus
uncos74117032uncos
uncus74014982uncus
undies73821962undies
unfit84518562unfit_
unhats91110622unhats
unify113611112unify
union54519792union
unions64216752unions
united74421542united
uniter64619142uniter
uniters73814172uniters
unities72520152unities
unknits1135552unknits
unlit55025462unlit_
unpins82312382unpins
unrigs7159002unrigs
unrips8199452unrips
uns35936762un__s
unsets64116162unsets
untie54425492untie
unties64326922unties
until53517742until
unto45824282un_to
unwit84417522unwit_
unzips17175272unzips
uts35534372u__ts
waits88333522waits
whits115923822whits
wits76044872_wits
writs86624382writs
zits136030292_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.296603685.8
2DLD Change Limit538001321.75030742.9
3Display Results1321320.0502640.0
 (SQL Overall)1786911322.09685253.3
 
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.