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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

68 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
uniters7381417(None) 
niters64624211_niters
uniter64619141uniter_
unites65024851unite_s
unmiters1037071unmiters
baiters94619302baiters
biters83925242_biters
bunters94717122bun_ters
citers85022982_citers
dunites8313592dunite_s
enters64425642en_ters
gaiters83516542gaiters
goiters84014442goiters
gunites8313122gunite_s
hinters103719582hinters
hunters103915732hun_ters
igniters9126232igniters
inciters103210672inciters
inditers93311052inditers
inters64328052in_ters
inviters11359642inviters
junipers1733932junipers
kiters105218592_kiters
knifers14537082knifers
knitters12336622knitters
linters73822632linters
liters65429882_liters
loiters74116612loiters
minters93822472minters
miters84328782_miters
munsters104010552munsters
niter55028972_niter_
nitery94412172_nitery
nites55736342_nite_s
nitres65519332_nitres
noters64021002_noters
nutters74215432nutters
punsters103310582punsters
punters93617042pun_ters
reuniters936422reuniters
sinters74024082sinters
smiters93414362smiters
snifters11318612snifters
snipers93311772snipers
suiters73618882suiters
tinters74221112tinters
titers64526412_titers
ulsters72711982ulsters
undoers82910582undoers
unifiers11237172unifiers
unitard838002unitard
unitards945622unitards
unitary1038612unitary
unite54828382unite__
united74421542unite_d
unities72520152unities
unitizers1843922unitizers
units54923432unit__s
universe1145252universe
unmiter9310392unmiter_
unmitres1036862unmitres
unsteps936212unsteps
unties64326922untie_s
ureters7311822ureters
utters63817122u_tters
waiters104218622waiters
winters103720482winters
writers105513492writers

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 Filter1786911076710.373479064.3
2DLD Change Limit107671682.84637832.4
3Display Results68680.0135230.8
 (SQL Overall)178691683.23255288.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.