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 “found” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
found9491784(None) 
bound84819581bound
fond86330951fo_nd
founds104814191founds
fount84727031fount
fund85624981f_und
hound95016481hound
mound83918311mound
pound84417861pound
round64318431round
sound64420021sound
wound94414211wound
abound9239862abound
around72712412around
bond75334362bo_nd
bounds94415802bounds
bund75530662_bund
cofound1335512cofound
could86517712could
count74932052count
fauld95214492fauld
faun76226622faun_
fauna84816512fauna
fauns84516752fauns
fecund1235432fecund
fend84832972f_end
feud86523022feu_d
feued94715662feued
fiend95312982fiend
find87532602f_ind
flued95021252flued
fluid94013962fluid
flung95114582flung
flunk125014382flunk
fohn106116552fohn_
fohns117310782fohns
foin77231562foin_
foined105915012foined
foins85523382foins
fold86528942fo_ld
fon66352272fo_n_
fonds95824822fo_nds
fondu96013972fo_ndu
fons76943892fo_ns
font77143752fo_nt
food86830572fo_od
ford86835492fo_rd
fou66743782fou__
foul77027582fou_l
fouled104315972fouled
fouls87221432fouls
founded124011422founded
founder114312562founder
foundry1433912foundry
founts94313382founts
four76226862fou_r
fours85521492fours
foxed165115212foxed
frond95316342frond
fud76335152f_u_d
fun66841142f_un_
fundi96814912f_undi
funds94119252f_unds
funk115825622f_unk
funs75235732f_uns
gourd71011902gourd
ground82310272ground
hounds104413132hounds
jocund1633622jocund
loud55228042lou_d
maund85515442maund
mould86015752mould
mounds93915132mounds
mount74128062mount
noun45724182noun_
nouns56717312nouns
oud47439072_ou_d
poind84217912poind
pond75530492po_nd
pounds93714382pounds
refound1157412refound
rotund737292rotund
rounds73615612rounds
sounds74616182sounds
stound7399902stound
swound10377632swound
unfound11127392unfound
would95513152would
wounds103811632wounds
yond86122312yo_nd
young977742young
zounds164310172zounds

Search took 6 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.220812231.8
2DLD Change Limit53800924.31312473.9
3Display Results92920.0601533.3
 (SQL Overall)178691924.59338905.1
 
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.