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 “affiancing” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
affiancing194184(None) 
advancing1643063a_dvancing
affiance1645653affianc__e
affianced1843033affianc_ed
affiances1745153affianc_es
affirming1843103affi_rming
affixing2264333affi__xing
affraying1943103affra_ying
affronting1742603affronting
cofinancing1951823cofinancing
effacing1744463eff_a_cing
financing1544073_financing
refinancing1742833refinancing
affecting1845234aff_ecting
affiant1348434affia___nt
affiants1445234affian__ts
affiliating1844174affiliating
affinity1744984affi_n_ity
afflicting1943484afflicting
affording1744024aff_ording
affricating2043964affricating
affrighting2252014affrighting
aliasing9310074a_lia_sing
aliening91510894a_lien_ing
aligning10158534a_lign_ing
alining81917044a_li_n_ing
allowancing1751594allowancing
announcing1342994announcing
anointing1038624anoi_nting
antiaging1149674antia_ging
arointing1049364aroi_nting
arranging1156304a_rranging
assigning1144674assign_ing
attaining1047224attain_ing
attainting1144784attainting
avalanching2051584avalanching
avianizing2345554a_vianizing
aviating12311024a_via_ting
balancing1435784_balancing
bechancing2044444bechancing
catfacing1744554catf_a_cing
chancing162810284__chancing
coffining1845484coffi_n_ing
dancing113611564___dancing
defacing15238684def_a_cing
defanging1535334def_anging
defencing16226694def_encing
defining133711804defi_n_ing
dezincing2244184dezi_ncing
distancing1447084distancing
enfacing1467294enf_a_cing
enhancing1545824_enhancing
entrancing1346784entrancing
evincing1446184_evi_ncing
facing125321574__f_a_cing
fainting123312164_fai_nting
fancying1735354__f_ancying
fanning113615074__f_anning
farcing133514004__f_arcing
feigning1335814_feign_ing
feinting123410834_fei_nting
fencing132411134__f_encing
financings1641854_financings
finding124116544__fi_nding
fining104223214__fi_n_ing
finking154016604__fi_nking
finning113615114__fi_nning
flanging132710584__flanging
flanking164211084__flanking
flinching18245834_fli_nching
flinging133310054_fli_nging
flinting123412344_fli_nting
flouncing1533904_flouncing
foining113013454_foi_n_ing
franking164310864__franking
friending1495554_friending
fringing133010904_fri_nging
frouncing1534764_frouncing
furnacing1543714_furnacing
glancing1247064__glancing
instancing1344644instancing
lancing103314124___lancing
mafficking2542644maffi_cking
mincing123314334__mi_ncing
offending1744094off_ending
officering1942144officering
outdancing1445224outdancing
penancing1436344_penancing
prancing132612164__prancing
prefinancing2051944prefinancing
refacing142512814ref_a_cing
refencing15188854ref_encing
refinding14259944refi_nding
refining122416864refi_n_ing
romancing1446044_romancing
sufficing1844884suffi__cing
tiffining1642914tiffi_n_ing
trancing112812024__trancing
unfencing1545954unf_encing
valancing1544744_valancing
wincing133413904__wi_ncing
zincing192910284__zi_ncing

Search took 10 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 Filter1786911614500.423422437.4
2DLD Change Limit1614501029.43617110.0
3Display Results1021020.0502040.0
 (SQL Overall)1786911029.90918033.2
 
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.