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

218 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
felsite103908(None) 
felsites1138071felsites
elite56230182_el_ite
falsie93513852falsi_e
falsity1335912falsity
feline94820142fel_ine
fellate10313432fellate
felsic1147052felsi_c
felsitic1345032felsitic
ferrite103312752ferrite
flite85424962f_l_ite
hessite1038992hessite
pelite84323002pel_ite
resite64128452re_site
website1235322website
wellsite1145132wellsite
albite8313313_albite
alsike1047913_alsike
amosite9313163amosite
aplite8316393apl_ite
beastie92412433beastie
bedside1156843bedside
bedsit9312843bedsit_
bedsits1037563bedsits
belie75630383bel_i_e
belike124616283bel_ike
belive115415303bel_ive
beside95114613be_side
beslime1146833beslime
blite76225353_bl_ite
calcite11413783calcite
celeste949653celeste
celestite11167033celestite
cerite84724873ce_rite
cerusite1047763cerusite
coesite9713623coesite
delaine8314793delaine
delate73827753del_ate
delete73620703del_ete
delime9314043del_ime
delist74625053delist_
delisted10310563delisted
delists84414173delists
delusive1245853delusive
density1137593density
depside1138413depside
desire7415303de_sire
despite10410123despite
eellike1138233eellike
elate55335883_el_ate
elide64922653_el_ide
elites66027123_el_ites
else45923083_els__e
eluate62315433_eluate
elusive1057003_elusive
elute54822573_el_ute
endite73817593_endite
ensile62616473_ensile
eosine64519413_eosine
evite85317683_e_vite
excite15310883_excite
falcate12311623falcate
false84818123fals__e
falsies103515013falsies
falsify1643613falsify
falsities1248133falsities
farside1138603farside
fease84824873feas__e
feasible1376093feasible
feasing113916653feasing
feast85932723feas_t_
feasted11310843feas_ted
feaster10812983feas_ter
feasts95116093feas_ts
febrile1237153febrile
feirie939553feiri_e
feist86230073feis_t_
feistier1136193feistier
feists94915313feis_ts
feisty12449293feis_ty
felicity1647923felicity
felid94717173fel_i_d
felids103111623fel_ids
felines104718073fel_ines
felinity1447293felinity
fellated1239563fellated
fellates11312753fellates
fellies104119743fellies
felling113321133felling
felloe93513923fel_loe
felspar1243283felspar
felstone1146863felstone
felt75146933fel__t_
felted103714653fel__ted
felting113515213felting
feltlike1534983feltlike
felts85324543fel__ts
feriae95618603fe_riae
ferine96422583fe_rine
ferity122813343fe_rity
ferlie92814053ferli_e
fermate122813003fermate
ferrate103014043ferrate
ferrites112312833ferrites
fertile10311733fertile
fescue1137493fe_scue
fesse86116333fe_s_se
fessing113812863fessing
fesswise1442353fesswise
fest74949443fe_s_t_
fester94723513fe_s_ter
festive1339773festive
fests85828043fe_s_ts
fete75734923fe___te
filiate10414233filiate
filister1137403filister
finite9316823f_inite
fissate103010033fissate
fissile10269653fissile
fleabite1354163fleabite
flexile1735073flexile
flit76539273f_l_it_
flited104616583f_l_ited
flites95122443f_l_ites
flits85625223f_l_its
flute86823753f_l_ute
flyte115713943f_l_yte
folate93320393fol_ate
foliate10513533foliate
folkie13369613folki_e
fomite113314073f_omite
fossate10388603fossate
fulmine1257963fulmine
fulsome1245363fulsome
fusile94313493f_usile
gelate73421263gel_ate
geste65920693ge_s_te
halite93624233hal_ite
hellkite1544933hellkite
hessites1138613hessites
illite63414923_illite
inosite7314063inosite
iolite63221983iol_ite
kelpie12308613kelpi_e
kernite1159473kernite
lenite6719983le_nite
leucite937753leucite
lewisite1154543lewisite
lite47054553__l_ite
melanite10512033melanite
melilite10410573melilite
melinite10411753melinite
mullite9313013mullite
nellie63614813nelli_e
newsie9138223newsi_e
oolite63319603ool_ite
pelisse967063pelisse
pelites93821993pel_ites
peltate92013773peltate
penlite9313243penlite
pensile92713543pensile
pensive122610393pensive
pepsine11310603pepsine
perlite9317323perlite
petite84320653pe_tite
polite83625073pol_ite
pulsate9510233pulsate
recite83625113re_cite
relate64033633rel_ate
reline65434353rel_ine
relist64628413relist_
relisted9312623relisted
relists73817063relists
relit55340683rel_it_
relive95120783rel_ive
requite162012483requite
reside74224933re_side
resile64627673re_sile
resit54241043re_sit_
resited85122423re_sited
resites74027803re_sites
resits64725573re_sits
resize154117723re_size
reslate73520593reslate
respite9513033respite
reunite7312713reunite
rewrite10311143rewrite
seaside839693seaside
selenite81713113selenite
selkie102811693selki_e
sensate7311893sensate
sessile739523sessile
site47052423___site
stellite839543stellite
subsite9412873subsite
sulfite10310473sulfite
sylvite13266353sylvite
tectite9310583tectite
tektite1136883tektite
tensile72612733tensile
tensity1039103tensity
tensive10269913tensive
teosinte845543teosinte
tergite8311003tergite
termite9313893termite
tillite7313563tillite
ulexite1445723ulexite
velate93720143vel_ate
velites103417303vel_ites
veloute1037733veloute
verite94323443ve_rite
versine102515173versine
verste94515633vers_te
websites1335183websites
wellie92814913welli_e
wellsites1244673wellsites
zeolite1638903zeolite
zoisite1635833zoisite

Search took 8 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 Filter1786911340270.403443402.0
2DLD Change Limit1340272186.70619986.1
3Display Results2182180.0762868.4
 (SQL Overall)1786912187.18524870.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.