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

96 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
court75532761court
fort76456441fo_rt
fount84727031fount
four76226861four_
fours85521491fours
fourth12357441fourth
blurt77625622blurt
boart78835932boart
bort65960962bo_rt
bourg84113842bourg
bourn75518482bourn
bout66353292bou_t
count74932052count
courts84216162courts
curt67051712_curt
doubt8720092doubt
dour56330432dour_
doura66518662doura
fart76860562f_art
fault85428312fault
flirt87424752flirt
flour84916452flour_
flours94414052flours
floury12449572floury
flout86226202flou_t
fluyt114614202fluyt
foist85730972foist
font77143752fo_nt
foot76248012fo_ot
for66952072fo_r_
fora75937392fo_ra
forb97131332fo_rb
ford86835492fo_rd
fore78351472fo_re
fork115930942fo_rk
form95836872fo_rm
forrit91916622forrit
forte86131462fo_rte
forth116222672fo_rth
forts86034452fo_rts
forty114824272fo_rty
forum108318762forum
fou66743782fou__
fought135112392fought
foul77027582fou_l
fouls87221432fouls
found94917842found
founts94313382founts
fourths13374952fourths
fruit85122222fruit
fur66637322f_ur_
furl77030882f_url
furs76735042f_urs
fury107727972f_ury
gourd71011902gourd
gout56646002gou_t
hour75827312hour_
houri85915232houri
hours85422382hours
hurt77142572_hurt
joust125122292joust
lour45430682lour_
lours55125292lours
loury85716752loury
lout45952142lou_t
mort66758832mo_rt
moult74728722moult
mount74128062mount
mourn77215012mourn
ort39465232_o_rt
our36042892_our_
ours47237562_ours
oust46747442_oust
out38072152_ou_t
port66059632po_rt
poult76928872poult
pour611527472pour_
pours74623182pours
pout65752552pou_t
roust55532062roust
rout46153282rou_t
sort46264812so_rt
sour45935892sour_
sours55230502sours
spurt77227982spurt
sturt56028962sturt
tort46967462to_rt
tour45530372tour_
tours55325862tours
tout46753822tou_t
wort76654752wo_rt
yogurt1037822yogurt
your78623432your_
yourn87512772yourn
yours85217872yours
yurt76435042_yurt

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.0931921408.6
2DLD Change Limit53800961.64032804.9
3Display Results96960.0332909.1
 (SQL Overall)178691961.766101184.0
 
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.