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

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
forerun103765(None) 
foreran10311791foreran
foreruns1146621foreruns
foregut1149162foregut
foreign1136832foreign
foreman12312362foreman
foremen12412922foremen
forerank1546752forerank
rerun58722152__rerun
boreen8314313bore_en
borer75131273borer__
borers85122683borer_s
coreign1037343coreign
corer75538873corer__
corers85231073corer_s
coverup1434623coverup
farer86733143farer__
farers95924053farer_s
fern76129323f__er_n
ferrum1147453fer_rum
firebug1383793firebug
fireman1249333fireman
firemen1238773firemen
firepan1236983firepan
firer811229253firer__
firers94922683firer_s
foehn11236323fo_e_hn
foeman11311233fo_eman
foemen11310523fo_emen
foetus958523fo_etus
foramen12310533foramen
forceful1644603forceful
forcer114917343forcer__
forcers124215713forcer_s
fore78351473fore___
forearm1238703forearm
forearms1336603forearms
forebay1538133forebay
forebrain1445163forebrain
foreby1438633fore_by
forebye1536353forebye
foredid1238503foredid
foredo10510823fore_do
foredone1249733foredone
forefend1545603forefend
forefront1546493forefront
forego1038903fore_go
foregone1238583foregone
foreground1572543foreground
foreguts1245563foreguts
forehand1537693forehand
foreland1239013foreland
foreleg1137743foreleg
forenoon1146823forenoon
forepaw1595613forepaw
foreranks1645293foreranks
forerunner13162513forerunner
fores85847103fore__s
foresaw1377133foresaw
foresee10414333foresee
foreseen1139103foreseen
foreskin1547023foreskin
forest94926743fore_st
forests104114953forests
foretop12117893foretop
forever1338953forever
forewarn14117173forewarn
forewent1439423forewent
forewing1539003forewing
foreworn14108863foreworn
forger104820773forger__
forgers115218183forger_s
forgery14419303forger_y
forker134717903forker__
forkers144615783forker_s
forkful1744773forkful
forlorn1096423forlorn
former114221403former__
formerly1645003formerly
formers128217953former_s
formful1545183formful
forrit91916623for_rit
fortune1068303for_tune
forum108318763fo__rum
forworn13107793forworn
foyer116416553foyer__
foyers125413133foyer_s
frenum1188803f_renum
frere85617723f_rer_e
freres94716173f_reres
gorgerin1044963gorgerin
govern1036823gover_n
korun9411923ko__run
modern939523moder_n
moneran9311113moneran
moreen8313343more_en
operon8811773_operon
outrun63213303_outrun
overrun1038023_overrun
reran57329103__reran
reruns66413743__reruns
sorer56236593sorer__
torero6313203torer_o
toreros7311343toreros

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271045.97022450.1
3Display Results1041040.0462260.9
 (SQL Overall)1786911046.42227824.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.