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

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

91 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
logjams174358(None) 
logjam1635361logjam_
loams75619862lo__ams
logans76319062log_ans
loggats9286452loggats
logways1434512logways
ogams84112682_og_ams
oghams1245852_oghams
bogans95714813bog_ans
boojums1842653boojums
cognacs1256043cognacs
cogways1634633cogways
dogdoms1295423dogdoms
dogears937513dogears
dogmas105011243dogma_s
dognaps1134393dognaps
engrams1038073engrams
flotsams1343383flotsams
foams105017953fo__ams
forams115115913fo_rams
gams76648883__g_ams
glams85822933__glams
gloams95210663glo__ams
goddams1233983goddams
grams85327313__grams
grograms1246023grograms
hogans105914313hog_ans
holograms1547363holograms
isograms1146473isograms
jams135231073___jams
jimjams1742073jimjams
jorams154810533jo_rams
kilograms1645043kilograms
lactams1136953lactams
lagans75717783lag_ans
lams66552263l___ams
laogais845813laog_ais
legals73412733leg_als
ligans76817733lig_ans
lignans8398853lignans
lingams104510193lingams
loads65323373lo__ads
loafs85616993lo__afs
loam65630483lo__am_
loamy105913343lo__amy
loans56026463lo__ans
locals83714503lo_cals
lochans1248833lochans
lockjaws2441873lockjaws
lockrams1643923lockrams
locums10478303lo_cums
logan68123283log_a_n
loges66534203log__es
loggers94616133loggers
loggets9378913loggets
loggias9356783loggias
logia68116603logia__
logics95711123log_ics
logins77820643log_ins
logions86211293logions
logjammed2251763logjammed
logograms1354693logograms
logons79818173log_ons
logos67225333log__os
logs57343113log___s
logway1335913logwa_y
longans84510813longans
longjump2041093longjump
longjumps215953longjumps
longways1543873longways
loofahs13364623loofahs
loofas9429833loofa_s
looms75124643lo__oms
loquats1645273loquats
lorans65117603lo_rans
lotahs9479873lo_tahs
lotas55926303lo_ta_s
loumas84812333louma_s
lovats939073lo_vats
ogam75120033_og_am_
ogham1138253_ogham_
oogamy1235633oog_amy
pogroms1237643pogroms
programs1339783programs
roams74919613ro__ams
slogans8407983slog_ans
sojas124716393so_ja_s
togas67823003tog_a_s
unjams1555703_unjams
wigwams1643883wigwams
yogas96615603yog_a_s

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit134027916.73319906.0
3Display Results91910.0332757.6
 (SQL Overall)178691917.17224915.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.