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 “ferreted” 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
ferreted123632(None) 
ferreled1234831ferreled
ferreter1136541ferreter
fermented1546622fermented
ferrate103014032ferrate_
ferrates113013402ferrates
ferrelled1343922ferrelled
ferret93021172ferret__
ferreters1246252ferreters
ferrets103111392ferret_s
ferrety13287012ferret_y
ferried113411522ferr_ied
ferrite103312752ferrite_
ferrites112312822ferrites
ferruled1263922ferruled
garreted1057522garreted
jerreed1535202jerre_ed
secreted1138632secreted
serrated92513422serrated
turreted935372turreted
aberrated1245873aberrated
accreted1336333accreted
aerated85322373ae_rated
arrested939153_arrested
barreled1137843barreled
befretted1544373befretted
berated104422133be_rated
berretta1044803berretta
berried103714043berr_ied
breveted1435623breveted
carpeted1338943carpeted
cerated103922473ce_rated
corrected1438113corrected
corseted11311473corseted
curveted1435293curveted
decreed112710253decre_ed
degreed10258883degre_ed
deleted93314903de_leted
depleted12258703depleted
derated93623503de_rated
deratted1048403deratted
deserted101012203deserted
erected103213993_erected
erred65915673_err__ed
eructed10228653_eructed
erupted10207163_erupted
everted112711853_everted
excreted1846153excreted
exerted152210053_exerted
faceted13509563f_aceted
farrowed1545283farrowed
farted105121783f_ar_ted
feared106320433fear__ed
feasted11310843fe_asted
federated1438413federated
fedexed1934073fe_dexed
feezed19439993fe__ezed
feinted11379623fe_inted
fellated1239563fellated
felted103714653fe__lted
fendered13258673fendered
fermate122813003fermate_
fermenter1497543fermenter
ferrel92810203ferr__el
ferrels10248623ferre_ls
ferreous1146033ferreous
ferreting13127683ferreting
ferries103521083ferr_ies
ferritic1347063ferritic
ferritin1147373ferritin
ferrotyped19252993ferrotyped
ferrule1035863ferrule_
ferrules1136163ferrules
ferrymen1643933ferrymen
feruled11318413fe_ruled
festered122512103festered
feted94420933f___eted
fetted104817893fe__tted
fettered12259493fettered
fevered14339723fe_vered
fidgeted1443893fidgeted
fileted1159093f_ileted
filleted1236603filleted
fleeted113310233f_leeted
flirted11428673flir_ted
floreated1346573floreated
forested12312463forested
forfeited1643793forfeited
foureyed1543663foureyed
fracted1339373f_racted
freed95223543f__re_ed
fretted113411853f_retted
fritted113611333f_ritted
fronted114011273f_ronted
frosted113211873f_rosted
fruited11389093f_ruited
furcated1437593furcated
furred104514433furr__ed
furrowed1563833furrowed
garroted1056783garroted
gorgeted1135353gorgeted
greeted93111383_greeted
hearted113314023hear_ted
helmeted1435833helmeted
herried113514453herr_ied
jereed144012063je_re_ed
jerreeds1653263jerre_eds
jerseyed1942733jerseyed
kerneled1344023kerneled
marketed1537323marketed
merited10313853me_rited
narrated9310323narrated
oersted839553oe_rsted
overrated13313073overrated
pargeted1238673pargeted
parroted1158843parroted
pelleted1138183pelleted
perfected1736633perfected
permeated1439353permeated
permuted1336703permuted
perorated12412443perorated
perverted1546073perverted
rearrested1145113rearrested
rebreed104611073rebre_ed
recrated112918583recrated
recreated12412533recreated
reerected1238613reerected
regrated102816323regrated
regreeted1136173regreeted
regretted1137233regretted
rerented92516163rerented
rerouted9311143rerouted
retreated10312613retreated
reverted122714713reverted
secrete9311073secrete_
secreter1038503secreter
secretes10410473secretes
seriated92717023seriated
serrate73017533serrate_
serrates82617003serrates
serried82513963serr_ied
targeted1037483targeted
telneted935073telneted
terete6319333te_rete_
terraced11318113terraced
terreen7257573terre_en
terrene72411033terrene_
terrenes82212593terrenes
terret63425623terret__
terrets72913573terret_s
velveted1533833velveted
weeted103913793we__eted
worrited1235743worrited

Search took 9 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.1731032896.0
2DLD Change Limit1461621538.73316736.7
3Display Results1531530.0632428.6
 (SQL Overall)1786911538.96919923.2
 
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.