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

189 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
forbs10572080(None) 
fobs96034271fo_bs
forb97131331forb_
forby135317671forby
fords95328181fords
fores85847101fores
forks125324681forks
forms105327051forms
forts86034451forts
orbs66626251_orbs
sorbs75022101sorbs
arbs66834732_arbs
barbs95928192barbs
bobs86340642bo_bs
bombs115818822bombs
boobs96221992boobs
boras75938302boras
bores76448252bores
borks115727702borks
borts76735452borts
burbs95423492burbs
carbs96031462carbs
cobbs115013982cobbs
cobs87043142co_bs
combs116122962combs
corby125018532corby
cords86030622cords
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442cor_s
curbs94821652curbs
darbs85323262darbs
dorks105724442dorks
dorms85723832dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
fabs98635862f_abs
fards96629842fards
fares85852872fares
farls85731112farls
farms106324952farms
faros85532022faros
farts88336842farts
feebs106112682feebs
feres86038182feres
ferns85220082ferns
fibs96329492f_ibs
fiords10498622fiords
fires85740752fires
firms105217422firms
firns86018542firns
firs76637712fir_s
fjords17405352fjords
flabs105818642flabs
floras94715692floras
flubs105515442flubs
foals85721692foals
foams105017952foams
fob86748332fo_b_
focus105815882focus
foes76543442fo_es
fogs87035002fo_gs
fohns117310782fohns
foils85025812foils
foins85523382foins
folds95221692folds
folks126017122folks
fonds95824822fonds
fons76943892fo_ns
fonts86124752fonts
foods95924162foods
fools86824202fools
foots85528282foots
fops96532682fo_ps
for66952072for__
fora75937392for_a
foram105124932foram
forams115115912forams
foray115023972foray
forays124813002forays
forbad122710502forbad
forbid123312432forbid
forbids13268262forbids
forbye14427882forbye
force105324272force
forces114422132forces
ford86835492for_d
fordo97218652fordo
fore78351472for_e
foreby1438632foreby
forest94926742forest
forge95126942forge
forges105024262forges
forgo94418332forgo
fork115930942for_k
forky156119642forky
form95836872for_m
forme105225992forme
formes114623712formes
fort76456442for_t
forte86131462forte
fortes95327182fortes
forth116222672forth
fortis95418612fortis
forty114824272forty
forum108318762forum
forums114611842forums
foss76431642fo_ss
fouls87221432fouls
fours85521492fours
fowls115518892fowls
foxes156321092foxes
foys105628292fo_ys
froes86126692froes
frogs96220772frogs
frons86124042frons
frows116623102frows
fubs96328792f_ubs
furls85322052furls
furs76735042fur_s
garbs86321412garbs
gobs76935572go_bs
gores65740372gores
gorms85619592gorms
gorps85316992gorps
herbs105520502herbs
hobs97038982ho_bs
horas86333092horas
horns86125332horns
jobs136529432jo_bs
kerbs115013672kerbs
kobs105831082ko_bs
koras95927112koras
kors85933012kor_s
lobs66441082lo_bs
lords64923502lords
lores55045402lores
loris55329152loris
mobs85737362mo_bs
moras76438762moras
mores76249642mores
morns75527442morns
mors65950062mor_s
morts75533562morts
nobs66436902no_bs
noris54928272noris
norms76019302norms
orb55736862_orb_
orby97519602_orby
orcs67025432_orcs
ores46056682_ores
ors35750112_or_s
orts46538332_orts
pores75849032pores
porks115124142porks
porns75527342porns
ports75934592ports
robs65837872ro_bs
sobs64941752so_bs
soras55041012soras
sorb68333042sorb_
sords64527802sords
sores55454282sores
sorns55028412sorns
sorts54536662sorts
sorus54527582sorus
tombs97818732tombs
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torts56138122torts
torus54329762torus
urbs65922052_urbs
verbs104614392verbs
wombs125813342wombs
words95425072words
works125621902works
worms105320752worms
worts88631182worts
yobs96028082yo_bs
yores85031322yores
zoris145320012zoris

Search took 2 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.0961861364.6
2DLD Change Limit538001891.67032215.6
3Display Results1891890.0464108.7
 (SQL Overall)1786911891.81298615.3
 
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.