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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

72 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
faciends144357(None) 
faciend1334801faciend_
facies113921592facie__s
facings134511262faci_ngs
fiends104110292f__iends
friends11396742f_riends
hacienda1442192hacienda
haciendas1542082haciendas
accents113511233_accents
achenes12313493_achenes
acids87121003_aci__ds
acinus8311253_aci_nus
addends10356053_addends
aliens65619213_alien_s
amends94713283_a_mends
ancients1098973ancients
appends1236393_appends
ascends10388203_ascends
attends8257593_attends
augends935883_augends
backbends2044093backbends
bartends1136793bartends
calends1039523ca_lends
faced117727653fac_e_d_
facers115519443fac_e_rs
faces106439433fac_e__s
facets116316653fac_e_ts
facials123310743faci_als
facias113415803faci__as
facileness1545503facileness
facing125321573faci_n_g
factions133013063faction_s
factoids1446243factoids
fadeins1168503fadein_s
fadings12469303fadi_ngs
faenas94412763fa__enas
fagins10513863fagi_n_s
faience1237523fa_ience
faiences1337053fa_iences
faints94818783fa_i_nts
famines123216263fami_nes
fancied133310603fancie_d_
fanciers13358083fancie_rs
fancies124018783fancie__s
fanciness1437673fanciness
fanions103713073fanion_s
farcies125317883farcie__s
farinas103215243fari_nas
fascines13310143fasci_nes
fastens105511753fasten_s
fatheads1536763fatheads
fattens105111713fatten_s
fazenda2043253fa_zenda
fazendas2143073fa_zendas
fends96324973f___ends
ficins113513983fici_n_s
fields104211043f__ields
fiend95312983f__iend_
finds95424823f__i_nds
forfends1544833forfends
friend10388933f_riend_
kalends1235683ka_lends
laciness102112553laciness
lacings105013653laci_ngs
lagends947273la_gends
patients1088763patients
raciness102413453raciness
racings105015133raci_ngs
salients839563salients
sapiens9310173sapien_s
sapients1037423sapients
scends95213003_sc_ends

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 Filter1786911461620.436409841.7
2DLD Change Limit146162728.73616731.0
3Display Results72720.0302400.0
 (SQL Overall)178691729.20219418.7
 
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.