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

72 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
logons7981817(None) 
cogons96818111cogons
logans76319061logans
logins77820641logins
logions86211291logions
logon615922311logon_
logos67225331logo_s
loons55731721lo_ons
agons66423782_agons
argons75018202argons
bogans95714812bogans
boons75031912bo_ons
borons85520542borons
bosons85016652bosons
codons96119462codons
cogon89120902cogon_
colons86028682colons
coons76737282co_ons
flagons1137972flagons
gogos77516522gogo_s
goons65326772go_ons
gorgons938852gorgons
hogans105914312hogans
isogons8217612isogons
lagans75717782lagans
lagoons839252lagoons
legions84611782legions
legong836962legong
legongs934542legongs
lemons84415052lemons
ligans76817732ligans
lions55923212l_ions
loans56026462lo_ans
lobos75921842lobo_s
locoes85516582locoes
locos75822602loco_s
lodens74315062lodens
logan68123282logan_
loges66534202log_es
logics95711122logics
login66025002login_
logion76013722logion_
logo57931762logo__
logoi69715942logo_i
logs57343112log__s
loins56728422lo_ins
longans84510812longans
loofs85623782lo_ofs
looks95124862lo_oks
looms75124642lo_oms
loon47344792lo_on_
loony86918962lo_ony
loops75723962lo_ops
loos49051122lo_o_s
loots55431422lo_ots
lorans65117602lorans
lorgnons943992lorgnons
lotions74614762lotions
lotos54724632loto_s
moons75331002mo_ons
morons84919542morons
noons54125282no_ons
poons75430972po_ons
slogans8407982slogans
solons65120022solons
tigons74112262tigons
toons55027532to_ons
toyons95512132toyons
trogons83410722trogons
wagons103911212wagons
yogins105114102yogins
zoons144919692zo_ons

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.1101624463.6
2DLD Change Limit82551722.43633887.9
3Display Results72720.0332181.8
 (SQL Overall)178691722.57969286.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.