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

152 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
golfs9561610(None) 
golds75421311golds
golf85731181golf_
goofs94821001goofs
gulfs94915301gulfs
rolfs84817121rolfs
wolfs116214161wolfs
boffs134915502boffs
bolas74733762bolas
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolts76232112bolts
bolus79125542bolus
calfs104919382calfs
coffs134916302coffs
coifs105718702coifs
colas75436772colas
colds85726972colds
coles76055062coles
cols66553082col_s
colts76633292colts
coofs105924712coofs
delfs94918672delfs
doffs125614332doffs
doles67843752doles
dolls66126922dolls
dols56943052dol_s
dolts65626312dolts
folds95221692folds
folks126017122folks
gaffs124914652gaffs
galas65731642galas
gales65442482gales
galls64729322galls
gals57946502gal_s
gaols66717572gaol_s
gelds75118342gelds
gels56836102gel_s
gelts65924612gelts
gilds75417522gilds
gills64728192gills
gilts64924262gilts
globs85616402globs
gloms85219782gloms
glops85619552glops
gloss64319622gloss
glows95518032glows
goads77022852goads
goals65521292goals
goas55239942go_as
goats65527302goats
gobos86219382gobos
gobs76935572go_bs
gods65438042go_ds
goers65520252goers
goes55644092go_es
gogos77516522gogos
gold65430162gol_d
golem8416112golem
golems939322golems
golfed11569762golfed
golfer104411182golfer
golfers114410082golfers
golly95121102golly
golosh1036462golosh
gonefs10439872gonefs
gongs74921612gongs
gonifs104310132gonifs
gonofs10459862gonofs
goods75124482goods
goof85436872goof_
goofy124915622goofy
gooks105422882gooks
goons65326772goons
goops86620962goops
goos57644912go_os
gores65740372gores
gorms85619592gorms
gorps85316992gorps
gos47155132go__s
goths96513002goths
gouts64826172gouts
gowds105814042gowds
gowks136011952gowks
gowns95115102gowns
goxes135018262goxes
goys86328412go_ys
guffs124414822guffs
gules64831042gules
gulf84929422gulf_
gulfy124612002gulfy
gulls65222982gulls
gulps84715072gulps
guls55930852gul_s
holds94623242holds
holes84748652holes
holks124720562holks
holms105117802holms
hols76946292hol_s
holts85627912holts
hoofs115721042hoofs
howfs144814502howfs
joles125230832joles
jolts125018882jolts
kolas94822232kolas
kolos94921212kolos
loafs85616992loafs
lolls512121732lolls
loofs85623782loofs
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mol_s
molts76032092molts
nolos54423352nolos
oafs76425262_oafs
offs107117012_offs
ogles65223182ogles
olds55926572_olds
oles46453472_oles
pelfs105016292pelfs
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562pol_s
polys105718762polys
poofs105222792poofs
poufs105616062poufs
roles56747982roles
rolf75134872rolf_
rolls55326232rolls
roofs85321152roofs
selfs85220242selfs
soles55547922soles
solos54830792solos
sols45448162sol_s
solus54726982solus
toffs116016722toffs
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolus55024482tolus
voles86234042voles
volts85421292volts
wolds95420182wolds
wolf105729562wolf_
woofs114918002woofs
yolks125412772yolks

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.326548131.9
2DLD Change Limit538001521.55034709.7
3Display Results1521520.0463304.3
 (SQL Overall)1786911521.92292971.4
 
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.