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

184 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
funds9411925(None) 
bunds85523541bunds
fends96324971fends
finds95424821finds
fonds95824821fonds
founds104814191founds
fuds86528561fu_ds
fund85624981fund_
fundi96814911fundi
fundus10429171fundus
funks125318911funks
funs75235731fun_s
ands57833612_ands
aunts55227632aunts
bands85233422bands
bends85628972bends
binds86627472binds
bonds86126842bonds
bounds94415802bounds
buds75235172bu_ds
bunas75126572bunas
bund75530662bund_
bundt85824852bundt
bundts95010842bundts
bungs85323862bungs
bunks115125082bunks
bunns74718292bunns
buns66243722bun_s
bunts75729802bunts
burds84626062burds
cuds76730472cu_ds
cunts76125122cunts
curds85725612curds
defunds12376752defunds
duads76515342duads
duds65530142du_ds
dunes65332172dunes
dungs75821972dungs
dunks105621192dunks
duns55140432dun_s
dunts65828412dunts
ends56528522_ends
fads86939872f_ads
fanes84639892fanes
fangs96224072fangs
fanos85926502fanos
fans76247372fan_s
fards96629842fards
faulds10438962faulds
faunas94013632faunas
fauns84516752faun_s
feds85234312f_eds
feeds94921142feeds
fend84832972fend_
fens76139762fen_s
feods99516852feods
feuds95914882feuds
fids87034742f_ids
fiends104110292fiends
find87532602find_
fines86644262fines
finis86824262finis
finks125424222finks
finos86226952finos
fins75849092fin_s
fluids10349422fluids
flunks13469862flunks
folds95221692folds
fond86330952fond_
fondu96013972fondu
fondus105210942fondus
fons76943892fon_s
fonts86124752fonts
foods95924162foods
fords95328182fords
found94917842found_
founts94313382founts
fronds106412342fronds
fubs96328792fu_bs
fucks144419252fucks
fucus105515892fucus
fud76335152fu_d_
fuddy135211152fuddy
fuels87117352fuels
fugs85730692fu_gs
fugus95914012fugus
fujis15379242fujis
fulls84623522fulls
fumes105224702fumes
fun66841142fun__
funded114413892funded
funder104016082funder
funders113813932funders
fundic12389082fundic
funest94316862funest
fungi95014132fungi
fungo94413132fungo
fungus10418182fungus
funk115825622fun_k
funky154315132funky
funny114614832funny
furls85322052furls
furs76735042fu_rs
fuses85628422fuses
fuss76027932fu_ss
fuzes175120222fuzes
guids75516152guids
gunks104517722gunks
guns55533482gun_s
hands95327382hands
hinds96721472hinds
hounds104413132hounds
hunks125321452hunks
huns76136932hun_s
hunts86826172hunts
hurds95219072hurds
junks164815972junks
kinds106221822kinds
lands65426902lands
lends65326252lends
lunas55025012lunas
lunes55337772lunes
lungs65223882lungs
lunks94822452lunks
lunts55826902lunts
maunds9519652maunds
mends84927692mends
minds85427122minds
mounds93915132mounds
muds75530652mu_ds
munis75022002munis
muns65535922mun_s
nuns45228232nun_s
nurds65518522nurds
ouds56430102ou_ds
pends85527192pends
ponds85323402ponds
pounds93714382pounds
puds75630512pu_ds
punas74826752punas
pungs85422222pungs
punks114822682punks
puns66641482pun_s
punts75828002punts
quads154515842quads
quids154917462quids
quods154610222quods
rands65930452rands
refunds11448622refunds
rends65129952rends
rinds64826142rinds
rounds73615622rounds
rudds74811702rudds
runes55530222runes
rungs611819402rungs
runs46438082run_s
runts55927632runts
rynds9569972rynds
sands65228582sands
sends65528242sends
sounds74616182sounds
sudds75513592sudds
suds56135292su_ds
sunns55017352sunns
suns45841902sun_s
surds65624662surds
tends65425582tends
tunas54224122tunas
tunes55332192tunes
tungs65520622tungs
tuns45138662tun_s
turds65021692turds
unde55825482_unde
undo55620152_undo
undy85015162_undy
uns35936762_un_s
urds55922432_urds
vends95520892vends
wands96425482wands
wends95822812wends
winds95425602winds
wounds103811632wounds
wynds126310372wynds
zounds164310172zounds

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.343520965.0
2DLD Change Limit538001841.69031834.3
3Display Results1841840.0464000.0
 (SQL Overall)1786911842.07985950.5
 
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.