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

104 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
dodges9611907(None) 
dodge86618121dodge_
dodged107514681dodged
dodgem116710031dodgem
dodgems12576441dodgems
dodger95817041dodger
dodgers105213821dodgers
dodoes85716101dodoes
doges75630161do_ges
lodges86820141lodges
wodges117413671wodges
badges103917362badges
bodes84935102bod_es
bodies94524142bodies
budges104820122budges
cadges104716702cadges
codes86247292cod_es
codger105814842codger
codgers115113922codgers
conges94928172conges
dadoes85616532dadoes
didies84621832didies
didoes85716962didoes
dinges83825422dinges
diodes83915782diod_es
dirges84915102dirges
dobies94422082dobies
dodder94712912dodder
dodders105511792dodders
dodgery13627782dodgery
dodgier10388242dodgier
dodgiest11308712dodgiest
dodgy116611462dodg_y
dodos75819392dod_os
does56554472do__es
doge66233802do_ge_
dogey105719512do_gey
dogeys115510662do_geys
dogged106017702dogged
dogger95216782dogger
doggers104413432doggers
doggies103613022doggies
dogies85022252dogies
dogs66440152do_g_s
doles67843752do_les
domes85735562do_mes
donees74519492donees
dongas84914612dongas
dongles93212872dongles
dongs76525812dong_s
doodies94218772doodies
doodles93614162doodles
dopes84935042do_pes
dories75232362dories
dosages92310802dosages
doses65938502do_ses
dosses76126272dosses
dotages92311792dotages
dotes65836692do_tes
doughs115912932doughs
douses74928932douses
doves94728152do_ves
dowdies123412732dowdies
dowses105718302dowses
doxies143917852doxies
dozes155226302do_zes
dredges10379342dredges
drudges10308872drudges
dudes75424372dud_es
edges75718722_edges
fadges114814022fadges
fidges114114382fidges
fodgel1136402fodgel
forges105024262forges
fudges114314492fudges
gorges85321892gorges
gouges86318692gouges
hedges115016242hedges
judges153713452judges
kedges124812942kedges
ledges84917982ledges
lodes66436912lod_es
lodge76520082lodge_
lodged913815702lodged
lodger86517682lodger
lodgers95113832lodgers
loges66534202lo_ges
longes75925572longes
midges103516472midges
modes85537412mod_es
nodes64633492nod_es
noodges9317702noodges
nudges84114732nudges
odes57243242_od_es
oodles73517182oodles
ridges85817002ridges
rodes614039082rod_es
rouges76022382rouges
sedges83817792sedges
stodges9309082stodges
todies74223552todies
wedges114614552wedges
wodge107212922wodge_
yodles103714332yodles

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 Filter178691825510.1101624463.6
2DLD Change Limit825511042.95327955.0
3Display Results1041040.0303466.7
 (SQL Overall)1786911043.09357772.7
 
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.