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

126 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
ferreting1312768(None) 
ferreling13136251ferreling
ferretings14133481ferretings
fermenting1646822fermenting
ferrelling1445042ferrelling
ferritin1147372ferritin_
ferritins1247252ferritins
ferruling13134402ferruling
ferrying15146232ferr_ying
secreting1279822secreting
serrating10513192serrating
accreting1446333accreting
aerating92820993ae_rating
arresting1038633_arresting
barreling1238043barreling
befretting1644793befretting
berating113220753be_rating
berrying14137363berr_ying
breveting1536263breveting
carpeting1439483carpeting
correcting15199293correcting
corseting12312173corseting
curveting1535353curveting
decreeing1335523decreeing
deleting103314423de_leting
depleting1378193depleting
derating103222273de_rating
deratting1139513deratting
deserting11713143deserting
erecting112415063_erecting
erring73816473_err__ing
eructing112110173_eructing
erupting11218443_erupting
everting122213133_everting
excreting1946433excreting
exerting162211153_exerting
faceting1438783f_aceting
farrowing1645873farrowing
farseeing1344383farseeing
farting114120753f_ar_ting
fearing113520033fear__ing
feasting122011323fe_asting
federating1548853federating
fedexing2034493fe_dexing
feeding123515073fe__eding
feeing104416503fe__e_ing
feeling113617073fe__eling
feezing204610163fe__ezing
feinting123410833fe_inting
fellating1339243fellating
felting113515213fe__lting
ferret93021173ferret___
ferreted1236323ferret_ed
ferreter1136543ferret_er
ferreters1246253ferreters
ferrets103111393ferret__s
ferrety13287013ferret__y
ferritic1347063ferriti_c
ferrotyping2052143ferrotyping
feruling1258873fe_ruling
festering132413173festering
feting104417793f___eting
fettering132310513fettering
fetting113517873fe__tting
fevering152510083fe_vering
fidgeting1544513fidgeting
fileting1239303f_ileting
filleting1335843filleting
fleeting122910323f_leeting
flirting12319013flir_ting
foresting13311363foresting
forewing1539003f_orewing
forfeiting1744133forfeiting
forgetting1544663forgetting
freeing113713913f__reeing
freezing21308323f_reezing
fretting122711523f_retting
fritting123510703f_ritting
fronting12310443f_ronting
frosting12311183f_rosting
fruiting12229063f_ruiting
furcating1537783furcating
furring114013133furr__ing
furrowing1644063furrowing
garroting1136953garroting
greeting103112353_greeting
hearting12513123hear_ting
helmeting1545503helmeting
herring113615873herr__ing
herrying15147013herr_ying
kerneling1464403kerneling
marketing1636513marketing
meeting103314963me__eting
meriting11314673me_riting
narrating10310343narrating
overrating14814183overrating
pargeting1338283pargeting
parroting1239153parroting
pelleting1237953pelleting
perfecting1847513perfecting
permeating1539913permeating
permuting1446543permuting
perorating13313123perorating
perverting1646623perverting
rearresting1245953rearresting
recrating121318783recrating
recreating131214573recreating
reerecting1339973reerecting
regrating111316203regrating
regreeting1237343regreeting
regretting1237783regretting
remeeting12311433remeeting
rerenting102617663rerenting
rerouting10311873rerouting
retreating111414763retreating
reverting132315133reverting
rewriting13310413rewriting
secretin10108343secretin_
secretins11108463secretins
seriating10916393seriating
serrying12167683serr_ying
targeting1137303targeting
telneting1035593telneting
terracing1237683terracing
weeting113816053we__eting
worriting1345553worriting

Search took 8 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 Filter1786911486410.1701051123.5
2DLD Change Limit1486411267.54619698.0
3Display Results1261260.0502520.0
 (SQL Overall)1786911267.76623009.4
 
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.