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

153 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
fomenter133926(None) 
fomented1437801fomented
fomenters1437851fomenters
cementer1239192cementer
commenter151410692commenter
fermenter1497542fermenter
foment113718302foment__
foments122912052foment_s
forester11313672forester
lamenter1038862lamenter
tormenter1146702tormenter
absenter1086773absenter
amender10349613_amender
ammeter1148393amme_ter
assenter867703assenter
augmenter1254123augmenter
bimester1236163bimester
biometer1239603biome_ter
cemented1338373cemented
cementers1338313cementers
center84421413__center
cointer93616723co_inter
combater1439383combater
comelier12310653comelier
comember1644163comember
comether1537253comether
commencer17147803commencer
commender16167923commender
commented16129613commented
commenters16139483commenters
commuter143010153commuter
computer144511513computer
concenter13312213concenter
consenter11312493consenter
counter94220153co_unter
coveter122912063cove_ter
cozener18328953cozen_er
decenter112412163decenter
demented12311273demented
dimeter10411893dime_ter
documenter1553283documenter
domineer1146273domineer
dopester1137253dopester
emender10649843_emender
enter54726383___enter
fainter103611053f_ainter
feater95224053f__eater
fencer114613533f__encer
fender103718723f__ender
fermented1546623fermented
fermenters15116533fermenters
fermentor1444693fermentor
fester94723513f__ester
fetter94120383f__etter
figeater1236953figeater
flaunter1135013flaunter
fleeter103210363f_leeter
flenser1036783f_lenser
flowmeter1743393flowme_ter
foetor939563fo_e_tor
fomenting1537233fomenting
fomite113314073fom_ite_
fomites123613203fom_ites
fonder104120063fo__nder
footer94320773fo__oter
foregoer1237253foregoer
foreseer1139013foreseer
forested12312463forested
foresters12312543foresters
forever1338953fore_ver
forfeiter1544173forfeiter
forgetter1345373forgetter
formatter1445463formatter
foster94322223fo__ster
fouette1038213fouette_
fouettes1137883fouettes
founder114312573fo_under
foveate1338363foveate_
foveated1536293foveated
foxhunter2241753foxhunter
fretter103412753f_retter
fromenties1546683fromenties
fromenty1645243froment_y
fronter103611583f_ronter
fumette1245523fumette_
fumettes1345773fumettes
gamester1137323gamester
geometer1138423geome_ter
homelier1338983homelier
honester1139713honester
immenser1244173immenser
incenter102212093incenter
indenter92311443indenter
inventer112410843inventer
jointer14379713jo_inter
jokester1934443jokester
lamented1138193lamented
lamenters1137683lamenters
loment84021473loment__
lomenta92710133loment_a
loments93413473loment_s
lomentum1244753lomentum
meeter83616503__meeter
melter83520113__melter
mender93520793__mender
mentee84121293__mentee
mentor8414363__mentor
meter75130323__me_ter
minter84425103__minter
misenter10310833misenter
modester1197483modester
molester1099373molester
moment103319683moment__
momenta11299853moment_a
momentary1645233momentary
momently1546473momently
momento11348903moment_o
momentoes13286253momentoes
momentos12338333momentos
moments113113123moment_s
momentum1144433momentum
mounter93713173mo_unter
odometer1147413odome_ter
offender1543723offender
oftener1035923often_er
omened93711003_omen_ed
omenta83411723_oment_a
omental93210423_omental
omentum1155933_omentum
omitter9298503_omitter
opener83910993_open_er
orienter838313orienter
orometer10310703orome_ter
pointer93814933po_inter
pomander1347083pomander
recenter102715443recenter
reenter73217793_reenter
renter64527413__renter
repenter102813863repenter
rimester1037813rimester
romancer1247293romancer
semester1038903semester
silenter838873silenter
smelter93311913_smelter
tenter64623933__tenter
tomenta9319833toment_a
tomentum1244993tomentum
tormented1245963tormented
tormenters1245823tormenters
tormentor1144363tormentor
udometer1146333udome_ter
venter94218723__venter
vomiter1237953vom_iter

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621536.33023090.4
3Display Results1531530.0632428.6
 (SQL Overall)1786911536.81326227.9
 
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.