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

125 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
forky15611964(None) 
corky145221151corky
dorky135518741dorky
folky159214711folky
foray115023971foray
forby135317671forby
fork115930941fork_
forks125324681forks
forty114824271forty
porky145019331porky
barky145721612barky
bork106933822bork_
borks115727702borks
borty105522832borty
bosky145612392bosky
cocky164215932cocky
coky137526822co_ky
conky145818742conky
cooky145321362cooky
corby125018532corby
cork106635692cork_
corks116028272corks
corny106023272corny
cory96941512cor_y
darky136018832darky
dork96531462dork_
dorks105724442dorks
dormy115817472dormy
dorty96220812dorty
dory85836232dor_y
farcy135217092farcy
ferly115517352ferly
ferny115816182ferny
ferry116020802ferry
firry115713532firry
flaky155715582flaky
flocky18468422flocky
fluky154512292fluky
foamy135313202foamy
fogey125617872fogey
foggy136714542foggy
fogy115923182fo_gy
foley115222302foley
folk116021542folk_
folks126017122folks
folksy16484982folksy
folly115022602folly
footy115820532footy
for66952072for__
fora75937392for_a
foram105124932foram
forays124813002forays
forb97131332for_b
forbs105720802forbs
forbye14427882forbye
force105324272force
ford86835492for_d
fordo97218652fordo
fords95328182fords
fore78351472for_e
foreby1438632foreby
fores85847102fores
forge95126942forge
forgo94418332forgo
forked145217142forked
forker134717902forker
form95836872for_m
forme105225992forme
forms105327052forms
formyl14276442formyl
fort76456442for_t
forte86131462forte
forth116222672forth
forts86034452forts
forum108318762forum
forwhy1834422forwhy
foxy176517752fo_xy
foy96044262fo__y
fozy197017162fo_zy
fray105428902f_ray
fry96226502f_r_y
funky154315132funky
furry116719282furry
fury107727972fur_y
furzy2010116062furzy
gooky135818032gooky
gorsy95915782gorsy
gory86129662gor_y
honky156218522honky
hooky155220262hooky
horny115619622horny
horsy116318392horsy
jerky196712422jerky
joky186215312jo_ky
kooky114412872kooky
larky125218872larky
lorry86315672lorry
lory75931712lor_y
mirky146315522mirky
moray105423792moray
murky145216682murky
narky126017802narky
nooky124814812nooky
oaky116419952_oaky
orby97519602_orby
orgy85218002_orgy
perky145319482perky
pocky165314602pocky
poky135922152po_ky
porgy116916122porgy
pork106929682pork_
porks115124142porks
porny106020192porny
rocky144513852rocky
rooky126117622rooky
sarky125521782sarky
sorry84618252sorry
tory75840542tor_y
wonky154011772wonky
wordy126916162wordy
work115528842work_
works125621902works
wormy137514252wormy
worry116114332worry
yolky15529522yolky

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 Filter178691538000.313570897.8
2DLD Change Limit538001251.73331044.4
3Display Results1251250.0333787.9
 (SQL Overall)1786911252.07985950.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.