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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

107 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
forrader123615(None) 
forrarder1343621forrarder
corrade101111042corrade_
corraded12128292corraded
corrades111211262corrades
forager114412562fo_rager
forayer13368952fo_rayer
forbade13259102forbade_
forsaker1545102forsaker
forwarder1644132forwarder
horrider1236532horrider
torrider936172torrider
abrader1038643_abrader
arrayer10136703_arrayer
barrater10310153barrater
boarder103910323boar_der
border94419973bo_r_der
borrower1384843borrower
broader103412613_broader
coleader1139183coleader
comrade12139213comrade_
comradery1793493comradery
comrades13149773comrades
corder94322883co_r_der
coriander1245663coriander
corridor1145033corridor
corrode101310573corrode_
corroded12147513corroded
corrodes111310333corrodes
degrader11247913degrader
fader94421513f___ader
farrier103514893farr_ier
ferrate103014043ferrate_
ferrates113013423ferrates
ferreter1136543ferreter
firrier103410133firr_ier
foamer114714313fo__amer
fodder114712113fo__dder
folder104317543fo__lder
fonder104120063fo__nder
forage104617003fo_rage_
foraged124812283fo_raged
foragers12349633fo_ragers
forages114217283fo_rages
foramen12310533fo_ramen
forayed14368593fo_rayed
forayers14277273fo_rayers
forbad122710503forbad__
forbare122310513forbare_
forbearer1444513forbearer
forbidder1642863forbidder
forbode13257963forbode_
forboded15215353forboded
forbodes14217103forbodes
forcer114917343fo_r_cer
forded115020393fo_r_ded
foreboder1545743foreboder
foregoer1237253foregoer
foreseer1139013foreseer
forester11313673forester
forever1338953fo_rever
forgather1643663forgather
forgave1435853forgave_
forger104820773fo_r_ger
forgiver1534183forgiver
forgoer1137693fo_rgoer
forker134717903fo_r_ker
forkier144311593fo_rkier
formate123115093formate_
formates132814293formates
formatter1445463formatter
former114221403fo_r_mer
forsake1436533forsake_
forsaken1543353forsaken
forsakers1644653forsakers
forsakes1536893forsakes
forwarded1743943forwarded
forwarders1743443forwarders
founder114312573fo_under
fourragere1451113fourragere
framer114817443f__ramer
frater94520593f__rater
furrier103513663furr_ier
furriner11267303furriner
furrower1464043furrower
grader84919693__grader
hoarder11329233hoar_der
joyrider1942663joyrider
loader74316313lo__ader
lowrider1234153lowrider
narrater838723narrater
nonreader1045913nonreader
order65019363_o_r_der
parader103914863_parader
pervader1444863pervader
portrayer1464003portrayer
reader73628293__reader
sorrier72313733sorr_ier
sorrower1165053sorrower
spreader1137483spreader
threader1256733threader
toreador945003toreador
torsade837593torsade_
torsades937213torsades
trader75218763__trader
treader84113833_treader
worrier102311683worr_ier

Search took 7 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 Filter1786911461620.406440125.6
2DLD Change Limit1461621076.36022981.4
3Display Results1071070.0462326.1
 (SQL Overall)1786911076.81226231.8
 
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.