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

122 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
unite5482838(None) 
dunite7315011dunite
gunite7414401gunite
nite45943581_nite
unit45140071unit_
united74421541united
uniter64619141uniter
unites65024851unites
units54923431units
unity84918491unity
untie54425491untie
alunite7311632alunite
anile54634462anile
anime75423202anime
anise55129702anise
ante46538902an_te
augite7312612augite
auntie64317702auntie
axite125218252axite
bite66546992_bite
blite76225352blite
boite74426322boite
cite65640342_cite
curite85222942curite
dite55547552_dite
dunites8313592dunites
dunnite857332dunnite
elite56230182elite
enate54428142enate
endite73817592endite
evite85317682evite
finite9316822finite
flite85424962flite
gite55438612_gite
gunites8313122gunites
ignite71410572ignite
incite83618722incite
indite73520312indite
invite93715022invite
kite85338232_kite
knife1210010132knife
knit85728142knit_
knits93914742knits
kunzite2053502kunzite
lenite6719982lenite
lite47054542_lite
lucite8313342lucite
lunate6316042lunate
mite66249402_mite
nice65534712_nice
nide55535782_nide
nine45842172_nine
nit37065942_nit_
niter55028972_niter
nites55736342_nites
nitre57519682_nitre
nits45741642_nits
nixe115722022_nixe
note46239962_note
pinite8321242pinite
quinte153414522quinte
quite144621462quite
reunite7312712reunite
rite45849452_rite
site47052412_site
skite95120042skite
smite75224862smite
snide64318722snide
snipe75320572snipe
snit46342472snit_
snits54124832snits
spite75430662spite
suite54829562suite
trite54730032trite
unakite1138742unakite
unbe65319272un_be
unciae83215312unciae
uncle7317052uncle
uncute82912132uncute
unde55825482un_de
undee65327272undee
undine7817262undine
undue66715552undue
unfit84518562unfit_
unfits93910292unfits
unify113611112unify
union54519792union
unique1558162unique
unisex1358352unisex
unitage838992unitage
uniters73814172uniters
unities72520142unities
unitive10310562unitive
unitize16310032unitize
unlet54133332unlet
unlike102614062unlike
unlit55025462unlit_
unlive92712332unlive
unmet74426392unmet
unmiter9310392unmiter
unmitre936992unmitre
unpile81914322unpile
unripe82012092unripe
unset54532432unset
unstep839222unstep
untied73720812untied
unties64326922unties
until53517742until
unto45824282un_to
unwet84423172unwet
unwhite1336812unwhite
unwise9510802unwise
unwit84417522unwit_
unwits9389892unwits
uranite72515692uranite
urate55432162urate
urine55026592urine
ute35335882u__te
utile54718932utile
white114920302white
wite75443272_wite
write85522832write

Search took 4 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.1061685764.2
2DLD Change Limit538001222.66020225.6
3Display Results1221220.0761605.3
 (SQL Overall)1786911222.84262875.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.