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

157 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
forgave143585(None) 
forgive1436191forgive
foggage1334112foggage
forage104617002for_age
forbade13259102forbade
forbare122310512forbare
forgat104018582forga_t
forge95126942forg__e
forgiven1542982forgiven
forgiver1534182forgiver
forgives1535752forgives
forgone1139342forgone
formate123115092formate
forsake1436532forsake
agave95314033__agave
airwave1344433airwave
aortae65115473aorta_e
bereave1258353bereave
borage93917013bor_age
borane84620213bor_ane
borate85026153bor_ate
brave104925503_br_ave
burgage1136633burgage
burgrave1443113burgrave
concave1439373concave
cordage11310063cordage
cordate10315223cordate
corkage1438373corkage
corrade101111043corrade
corsage1039803corsage
crave105626313_cr_ave
drave95219273_dr_ave
engrave1137133engrave
ergate7315143_ergate
fave105532963f___ave
feriae95618603feria_e
fermate122813003fermate
ferrate103014043ferrate
florae94713883flor_a_e
foggages1434213foggages
fogie96719003fo_g_ie
folate93320393fo_late
foliage1147533foliage
foliate10513533foliate
footage1148843footage
fora75937393for_a__
foraged124812283foraged
forager114412563forager
forages114217283forages
foram105124933for_a_m
foramen12310533for_amen
forams115115913for_ams
foray115023973for_a_y
forayed14368593for_ayed
forayer13368953for_ayer
forays124813003for_ays
forbad122710503forba_d
forbode13257963forbode
forbore12249673forbore
forbye14427883for_bye
force105324273for__ce
fordable1439593fordable
fordone1149383fordone
fore78351473for___e
forearm1238703forearm
forebye1536353forebye
foredate12310913foredate
foreface1647113foreface
foregone1238583foregone
forename1347853forename
foresee10414333foresee
forever1338953for_ever
forgather1643663forgather
forgeable1545403forgeable
forged115519323forg_ed
forger104820773forg_er
forgers115218183forgers
forgery14419303forgery
forges105024263forg_es
forget106326393forg_et
forgetive16124463forgetive
forgets113813793forgets
forging124114723forging
forgivers1643713forgivers
forgo94418333forg__o
forgoer1137693forgoer
forgoes11311353forgoes
forgot104318133forg_ot
formable1539503formable
formal113215213forma_l
formals123312893formals
formant123416003formant
format113021363forma_t
formates132814293formates
formative1747963formative
formats123113573formats
forme105225993for__me
formee113919943for_mee
forrader1236153forrader
forsaken1543353forsaken
forsaker1545103forsaker
forsakes1536893forsakes
forte86131463for__te
fortune1068303fortune
forward1438293forward
fossae95510373fossa_e
fossate10388603fossate
foveae1237563fovea_e
foveate1338363foveate
foxglove2241693foxglove
frae75330473f_r_a_e
frame105821803f_r_ame
frigate11311063frigate
frogeye1443813frogeye
fromage1336753fromage
furane94015493fur_ane
furcate12310453furcate
furnace1235943furnace
furtive1337173furtive
gave84634053___gave
gorge76423893gorg__e
grave94624873_gr_ave
greave104611493_greave
margrave1444793margrave
misgave13298283misgave
morae75831193mor_a_e
morale85220553mor_ale
morgan9311373morga_n
morgans10310123morgans
morgue938113morg_ue
mortgage1244213mortgage
nongame1038183nongame
octave11157343_octave
ogive9379093_o_give
orate55133303_or_ate
organ6915393_orga_n
organa789213_organa
organs7912913_organs
orgasm966303_orgasm
orgone71110913_orgone
ornate6315143_ornate
outgave11259563outgave
portage103013643portage
rave75542093__r_ave
reave84528023__reave
regave104713383_regave
soave84219053so__ave
sorbate9311733sorbate
thrave126010273thr_ave
togae67020113to_ga_e
togate74515683to_gate
torsade837593torsade
trave85223033_tr_ave
virgate1138733virgate
vorlage1136403vorlage
wordage1236503wordage
zouave1833573zo_uave

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 Limit1340271577.25018486.5
3Display Results1571570.0632492.1
 (SQL Overall)1786911577.71923149.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.