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

105 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
unites6502485(None) 
dunites8313591dunites
gunites8313121gunites
nites55736341_nites
unite54828381unite_
united74421541united
uniter64619141uniter
uniters73814171uniters
unities72520151unities
units54923431unit_s
unties64326921unties
alunites8310702alunites
animes84719592animes
anises64826692anises
antes56334322an_tes
augites8312182augites
aunties73920072aunties
axites134913832axites
bites75641172_bites
blites84721212blites
boites84322702boites
cites74435592_cites
curites93919862curites
dites66339152_dites
dunite7315012dunite_
dunnites947172dunnites
elites66027122elites
enates64026432enates
endites83717062endites
evites94916472evites
finites10315922finites
flites95122442flites
frites94922482frites
gites65630182_gites
gunite7414402gunite_
ignites81310582ignites
incites93218482incites
indites83618982indites
invites103915812invites
kites95432542_kites
knifes136210212knifes
knits93914742knit_s
knives13458552knives
kunzites2143242kunzites
lenites7818442lenites
lucites9311862lucites
lunies64723012luni_es
mites75141802_mites
nates55238332_nates
nides65229132_nides
nines55937342_nines
nite45943582_nite_
niter55028972_niter
niters64624212_niters
nitres65519332_nitres
nits45741642_nit_s
nixes124519622_nixes
notes55034582_notes
pinites9319532pinites
punties94520782punties
quintes164114712quintes
reunites8312472reunites
rites54442552_rites
sites56045432_sites
skites104418042skites
smites83921922smites
snipes83917392snipes
snits54124832snit_s
spites84127332spites
suites63727402suites
unakites1237542unakites
uncles8317162uncles
undies73821962undies
undines8716082undines
undoes73917402undoes
unfits93910292unfit_s
unfixes17238112unfixes
ungues7412122ungues
unifies102714712unifies
unions64216752unions
uniques1667442uniques
unisex1358352unisex
unit45140072unit__
unitages938272unitages
unitizes1739132unitizes
unity84918492unit_y
unlives102010952unlives
unmiter9310392unmiter
unmiters1037072unmiters
unmitres1036862unmitres
unmixes16197752unmixes
unpiles92112782unpiles
unsets64116162unsets
unstep839222unstep
unsteps936212unsteps
untie54425492untie_
untied73720812untied
unwits9389892unwit_s
uranites82514642uranites
urates65027762urates
urines64724122urines
utes45930882u__tes
whites123919882whites
wites85536962_wites
writes94420332writes

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 Filter178691825510.346516448.0
2DLD Change Limit825511052.56332208.7
3Display Results1051050.0303500.0
 (SQL Overall)1786911052.93960799.9
 
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.