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

130 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
filleting133584(None) 
billeting1236631billeting
fileting1239301fi_leting
bulleting1236642bulleting
colleting12311052colleting
fellating1339242fellating
fidgeting1544512fidgeting
filiating1339242filiating
filling113520802fill__ing
filliping1544232filliping
filtering13199712filtering
fleeting122910322f_leeting
fullering1336652fullering
galleting1137622galleting
gimleting1343862gimleting
palleting1238732palleting
pelleting1237952pelleting
tillering1037862tillering
alleging1038473_alleging
balloting1238383balloting
billing103823853bill__ing
billowing1545873billowing
bulletin1046773bulletin_
bulletins1146333bulletins
collating12312753collating
collecting1548283collecting
deleting103314423_deleting
depleting1378193depleting
dieting93616833di__eting
dilating102714903di_lating
diluting10248983di_luting
faceting1438783f_aceting
falling113621583fall__ing
fallowing1666433fallowing
faltering132211113faltering
faulting12237733faul_ting
felling113321133fell__ing
fellowing1655923fellowing
felting113515213f_el_ting
ferreting13127683ferreting
feting104417793f___eting
fielding13206863fiel_ding
fighting162710083fi_ghting
filching1736113fi_lching
filing103823763fi_l__ing
fillet95027083fillet___
filleted1236603fillet_ed
fillets103414753fillet__s
fillings122910503fill__ings
filmgoing1641713filmgoing
filming133210353fi_l_ming
filmsetting1751873filmsetting
filtrating1445973filtrating
fingering1439183fingering
fisting113818123fi__sting
fitting113516563fi__tting
fixating1936183fi_xating
flatting123511253f_latting
fleecing14347573f_leecing
fleeing113511293f__leeing
fleering123811283f_leering
flexing18358993f__lexing
fleying14329873f__leying
flighting1736103flighting
flinting123412343f_linting
flirting12319013f_lirting
fliting113514613f__liting
flitting123010883f_litting
floating123111883f_loating
flouting122610473f_louting
fluting113815093f__luting
flyting14378553f__lyting
foliating1339253foliating
following1665753following
frilling123011493frill__ing
fulling114019703full__ing
gibbeting1542903gibbeting
gilling93520383gill__ing
gillnetting1351543gillnetting
gillying13306813gill_ying
gleeting10279173_gleeting
helmeting1545503helmeting
hilling113821773hill__ing
hilloaing1375433hilloaing
hilloing12158293hill_oing
hilting113316893hi_l_ting
hollering1337743hollering
illuding1035803_illuding
illuming1135873_illuming
inletting1087873_inletting
jilting153211743ji_l_ting
killing123118723kill__ing
kilting123213853ki_l_ting
lilting83515383li_l_ting
mildening1345663mildening
mildewing1643723mildewing
milling103223683mill__ing
milting103619123mi_l_ting
nilling83619563nill__ing
picketing1835683picketing
pilfering1536383pilfering
pillaging1345553pillaging
pillaring1237643pillaring
pilling103722563pill__ing
pillowing1545493pillowing
piloting1139693pi_loting
pollening1236923pollening
polluting1235703polluting
rilling84023623rill__ing
riveting12139443ri_veting
signeting1136223signeting
silting83320483si_l_ting
silvering1337913silvering
sleeting93114163_sleeting
tableting1236343tableting
telneting1035593telneting
ticketing1635633ticketing
tilling83522773till__ing
tilting83417103ti_l_ting
toileting1036263toileting
valeting1238843_valeting
villein1036753ville_in_
villeins1136033ville_ins
violating1337423violating
volleying1643763volleying
wildering1456733wildering
willing113821613will__ing
willowing1645323willowing
willying15306713will_ying
wilting113515913wi_l_ting

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411308.06318434.9
3Display Results1301300.0462826.1
 (SQL Overall)1786911308.26521620.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.