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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

111 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
foretop1211789(None) 
foretops13137481foretops
foetor939562fo_etor
foredo10510822foredo_
forego1038902forego_
foretold1256492foretold
boredom1236943boredom
cartop104213563car_top
cooktop1544043cooktop
doorstop1143113doorstop
farebox1943823farebox
feretory1447513feretory
fetor81214533f__etor
firebox1944453firebox
firedog1244473firedog
firepot1248733firepot
firetrap1344863firetrap
flattop1244403flattop
floret9321123floret__
florets1039853floret_s
foetal9311883fo_etal
foetid10510513fo_etid
foetors1039763fo_etors
foetus958523fo_etus
fordo97218653for_do_
fore78351473fore___
forearm1238703forearm
forebay1538133forebay
forebode1448273forebode
forebody1745153forebody
foreboom1546133foreboom
foreby1438633fore_by
forebye1536353forebye
foredid1238503foredid
foredoes12310803foredoes
foredone1249733foredone
foredoom1445813foredoom
forefoot1448153forefoot
foregoer1237253foregoer
foregoes1239523foregoes
foregone1238583foregone
foregut1149163foregut
forehoof1746603forehoof
foreign1136833foreign
foreknow1842763foreknow
foreleg1137743foreleg
forelock1745593forelock
foreman12312363foreman
foremen12412923foremen
foremost1348583foremost
forenoon1146823forenoon
forepaw1595613forepaw
foreran10311793foreran
forerun1037653forerun
fores85847103fore__s
foresaw1377133foresaw
foresee10414333foresee
foreshow1785893foreshow
forest94926743fore_st
forestal11410283forestal
forestay1448193forestay
forested12312463forested
forester11313673forester
forestry1446723forestry
forests104114953forests
foretell1146123foretell
foretime1348213foretime
foretoken1644353foretoken
foretooth1543883foretooth
foretopman1751683foretopman
foretopmen1752383foretopmen
forever1338953forever
foreword15118963foreword
foreworn14108863foreworn
forget106326393forget__
forgets113813793forget_s
forgo94418333for_go_
forgot104318133for_got
formol112910333for_mol
forsook1446003forsook
fort76456443for_t__
forte86131463for_t_e
fortes95327183for_tes
forth116222673for_t_h
fortis95418613for_tis
forts86034453for_t_s
forty114824273for_t_y
fouette1038213fouette
fret75845043f_ret__
frets85523403f_ret_s
fretty1249223f_retty
fronton1037203fronton
hardtop1345053hardtop
hereto9313693hereto_
housetop1343903housetop
netop7312343__netop
nonstop9106923nonstop
orator6314533_orator
orlop7410903_or_lop
overtop1237723_overtop
postop10511943po_stop
preop94715873_pre_op
pretor8315753_pretor
rebop9313283__rebop
redtop937973__redtop
rolltop944043rolltop
rooftop12133253rooftop
torero6313203torero_
toreros7311343toreros
treetop945523treetop
wiretap12145723wiretap

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271116.29621287.6
3Display Results1111110.0462413.0
 (SQL Overall)1786911116.73226543.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.