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

143 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
faiences133704(None) 
faience1237511faience_
cadences1338472cadences
faeces114713122fa_e_ces
faineances1553522faineances
fences114617112f__ences
fiances12310672f_iances
patiences1367432patiences
saliences11108062saliences
sapiences13116422sapiences
sciences1238772sciences
valences1388512valences
absences1247673absences
affiances1745153affiances
agencies1138743_agencies
agenes74720253_agen_es
akenes104817343_aken_es
alienees8118653alienees
ambiences1545253ambiences
amerces1149853_amerces
arenes64928393_aren_es
audiences1246003audiences
avenges1157543_avenges
avenses1049643_avenses
avenues1057183_avenues
balances1279973balances
cadence1239063cadence_
cadenced1435523cadenced
cadencies1447323cadencies
cayennes1345013cayennes
clarences1346453clarences
dances95120653da__nces
defences1439633defences
dienes75719903_dien_es
eminences1347403eminences
essences1047563essences
evidences1556333evidences
evinces1237803evi_nces
exigences1946323exigences
faces106439433fa___ces
faciends1443573facien_ds
faenas94412763fa_en_as
faeries104118993fa_eries
failles102914123fai_lles
failures1135163failures
faineance1443363faineance_
fainer94717243fai_n_er
fainest10417703fai_n_est
fainted114211723fai_nted
fainter103611053fai_nter
fainters11349693fai_nters
faintest1139073fai_ntest
faints94818783fai_n_ts
fairies103516043fai_ries
fairness1136563fairness
fakeries1559833fakeries
falces115216003fa__lces
famines123216263famin_es
fancies124018783fa__ncies
fanes84639893fa__n_es
fannies103415643fa_nnies
farces115223323fa__rces
fasces114914543fa__sces
fauces114916153fa__uces
fazendas2143073fazendas
feasances1445403feasances
feces105625363f__e_ces
fence105319913f__ence_
fenced124412713f__enced
fencer114613533f__encer
fencers123810623f__encers
fiance11310743f_iance_
fiancee1238953f_iancee
fiancees1335103f_iancees
fices106031163f_i__ces
fiends104110293f_ien_ds
fierce11348913f_ierce_
fiercer12356953f_iercer
fiercest13216143f_iercest
finances1338653finances
fincas113512073f_i_ncas
finches153914193f_i_nches
fines86644263f_i_n_es
flamencos1642423flamencos
fleeces12399643f_leeces
flenches163410533f_lenches
flenses1039473f_lenses
flinches16358953fli_nches
florences1446893florences
flounces1335103flounces
fluencies1445933fluencies
frenches163311633f_renches
friended1335033friended
friends11396743frien_ds
friezes19418913frie_zes
fringes113514103fri_nges
frounces1336183frounces
gaieties9310183gaieties
hances115621283ha__nces
jaunces16307423ja_unces
laitances1145613laitances
lances84824103la__nces
latencies1147773latencies
launces9329003la_unces
leniences1148143leniences
licences12129323licences
lucences12137313lucences
minces104420803_mi_nces
nances83618643na__nces
nascences1346223nascences
nieces84112713_nie_ces
offences1645023offences
painches1588913pai_nches
patencies1349173patencies
patience1247513patience_
pieces104217273_pie_ces
pierces113411193_pierces
potences12710693potences
princes113015143pri_nces
quinces183210433qui_nces
radiances1247693radiances
rances84625443ra__nces
refences13311843refences
saices84221803sai__ces
salience10117893salience_
saliencies1246133saliencies
sapience12106613sapience_
sapiencies1445113sapiencies
science1138783science_
silences10310073silences
spences113413923_spences
tangences1246443tangences
tierces93710453_tierces
trienes74118413trien_es
trientes82812123trientes
unfences1337933unfences
valances1398763valances
valence1268763valence_
valencies1446413valencies
valiances1487203valiances
variances14117363variances
wienies102213683_wienies
winces114819113_wi_nces

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621438.23617746.7
3Display Results1431430.0433325.6
 (SQL Overall)1786911438.45221141.9
 
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.