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

168 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
filiating133924(None) 
foliating1339251foliating
affiliating1844162affiliating
dilating102714902dil_ating
fellating1339242fellating
fileting1239302fil_eting
filiation121110242filiation
filiations13119092filiations
filleting1335842filleting
filtrating1445972filtrating
fixating1936182fi_xating
flinting123412342f_linting
flirting12319012f_lirting
fliting113514612f_li_ting
flitting123010882f_litting
floating123111882f_loating
militating1348822militating
vitiating1338402vitiating
ablating11311993abl_ating
afflicting1943483afflicting
airlifting1443343airlifting
aliasing9310073_aliasing
aviating12311013_aviating
billeting1236633billeting
bleating113514503_bleating
bloating113512813_bloating
ciliation111112493ciliation
ciliations121111003ciliations
cleating113518133_cleating
collating12312763collating
defoliating1645823defoliating
delating103119603del_ating
delisting112710503delisting
deviating14311083deviating
dictating1338883dictating
diluting10248983dil_uting
disrating11714553disrating
elating83423083_el_ating
enlisting1038343enlisting
epilating12310963epil_ating
exfoliating2243393exfoliating
expiating1938543expiating
facilitating1854003facilitating
fainting123312163f_ainting
fating105328673f___ating
feinting123410833f_einting
felting113515213fel__ting
fidgeting1544523fidgeting
fighting162710083fi_ghting
filching1736113fil_ching
filiate10414233filiat__e
filiated12610083filiat_ed
filiates11412663filiat_es
filing103823763fil___ing
filling113520803fil__ling
filliping1544233filliping
filmgoing1641713filmgoing
filming133210353fil__ming
filmmaking2242093filmmaking
filtering13199723filtering
finicking1954463finicking
finiking16277073fini_king
finishing1645843finishing
fisting113818123f__isting
fitting113516563f__itting
flailing12298923f_lailing
flaking154114493f_l_aking
flaming134216443f_l_aming
flaring114116803f_l_aring
flatling123410013f_l_atling
flatting123511253f_latting
flawing143812563f_l_awing
flaying143914463f_l_aying
fleeting122910323f_leeting
flicking184110043f_licking
flighting1736103flighting
flinging133310053f_linging
flipping16307663f_lipping
flouting122610473f_louting
fluting113815093f_l_uting
flyting14378553f_l_yting
foisting122910503f_oisting
foliation121110793foliation
foliations1399943foliations
folioing1237573foli_oing
fritting123510703f_ritting
fruiting12229063frui_ting
fulminating1744683fulminating
fumigating1744653fumigating
furcating1537783furcating
gelating103015733gel_ating
glinting103210053_glinting
gloating102611463_gloating
hilting113316893hil__ting
humiliating1744073humiliating
ideating10311703_ideating
imitating1238763_imitating
initiating1149623initiating
iodating1038823_iodating
jilting153211743jil__ting
kilting123213853kil__ting
lariating10311783lariating
librating1239053librating
lifting113313273__lifting
ligating102212283li_gating
lilting83515383__lilting
limiting1138813limi_ting
linting83820983__linting
liquating1946313liquating
listing84020593__listing
litigating1246743litigating
mediating13311203mediating
migrating13910533migrating
milting103619123mil__ting
misdating131010663misdating
miseating121215433miseating
mismating141211823mismating
misrating121014853misrating
mitigating1447433mitigating
nictating1237573nictating
nidating1039783ni_dating
nitrating10312673nitrating
obligating1445803obligating
obviating1545053obviating
officiating2052923officiating
opiating11410093_opiating
palliating1347883palliating
palpating1438533palpating
pillaging1345553pillaging
pillaring1237643pillaring
piloting1139693pil_oting
pirating11314513pi_rating
plaiting113113513_plaiting
plating103823073_pl_ating
pleating112916053_pleating
pulsating1236343pulsating
radiating111112123radiating
relating92725443rel_ating
relisting102414353relisting
salivating1447433salivating
satiating10311803satiating
seriating10916403seriating
sibilating1346963sibilating
silting83320483sil__ting
sinuating1039683sinuating
situating1038883situating
slating83724653_sl_ating
slitting93012583_slitting
solating9315593sol_ating
solvating1336443solvating
splinting1238193splinting
splitting1236563splitting
spoliating1366963spoliating
striating10914193striating
sulfating1338063sulfating
tailgating1244903tailgating
tilting83417103til__ting
titivating1445323titivating
titrating10310113titrating
uplifting1534963uplifting
validating1545833validating
valuating1338643valuating
variating13310943variating
vibrating1537473vibrating
vilifying1944493vilifying
violating1337433violating
visiting1238393visi_ting
wilting113515913wil__ting

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 Filter1786911486410.1701051123.5
2DLD Change Limit1486411686.58022589.8
3Display Results1681680.0602800.0
 (SQL Overall)1786911686.81026239.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.