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

92 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
dodger9581704(None) 
codger105814841codger
dodder94712911dodder
dodge86618121dodge_
dodged107514681dodged
dodgem116710031dodgem
dodgers105213821dodgers
dodgery13627781dodgery
dodges96119071dodges
dodgier10388241dodgier
dogger95216781dogger
lodger86517681lodger
badger105415072badger
booger94816552booger
budger104617702budger
cadger105013892cadger
codder104416332codder
coder86134212cod_er
codgers115113922codgers
conger95024272conger
dagger95017292dagger
danger83722822danger
digger94616082digger
dinger85323662dinger
dobber114015412dobber
docker134417652docker
dodders105511792dodders
doddery13516852doddery
dodgems12576442dodgems
dodgy116611462dodg_y
dodoes85716102dodoes
doer57734702do__er
doffer133911352doffer
doge66233802do_ge_
dogear838192do_gear
doges75630162do_ges
dogey105719512do_gey
dogged106017702dogged
doggers104413432doggers
doggery13448262doggery
doggier103810942doggier
doodler93310152doodler
doozer163910462doozer
doper86128392do_per
dopier93515922dopier
dormer94415892dormer
dorper94314562dorper
dorser74819172dorser
doser66228562do_ser
dosser74417972dosser
doter65428622do_ter
dotier73917032dotier
dotter74419342dotter
dourer74215272dourer
douser75621632douser
dowager1245802dowager
dowdier12328572dowdier
dower95027702do_wer
downer104414922downer
dowser104716082dowser
dozer158419272do_zer
dozier163611632dozier
dredger10347442dredger
drudger10328322drudger
edger75215932_edger
fodder114712112fodder
fodgel1136402fodgel
fogger114414772fogger
forger104820762forger
gorger86116982gorger
gouger86014362gouger
hedger114912632hedger
hogger114615082hogger
jogger154713162jogger
judger154411442judger
ledger85914362ledger
lodge76520082lodge_
lodged913815702lodged
lodgers95113832lodgers
lodges86820142lodges
logger86420002logger
longer75823192longer
monger94418332monger
nodder84811942nodder
nudger85111632nudger
odder74515392_odder
podgier11338722podgier
roger64521412ro_ger
tonger74719682tonger
wodge107212922wodge_
wodges117413672wodges
yodler10389942yodler

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 Limit82551922.60631677.3
3Display Results92920.0165750.0
 (SQL Overall)178691922.73265406.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.