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

170 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
filisters123700(None) 
filister1137401filister_
fillisters1343871fillisters
blisters104015082_blisters
enlisters937112enlisters
fibsters13126412fi_bsters
filiates11412662filiate_s
filibusters1651412filibusters
fillister1244422fillister_
filters103816552fil__ters
finishers1545352finishers
flirters11337932f_lirters
flitters114312172f_litters
flusters113811502f_lusters
glisters93912602_glisters
klisters123910482_klisters
listers74026532__listers
ministers1139622ministers
pilasters1138222pilasters
afflicters1852243afflicters
assisters936353assisters
balusters1136643balusters
banisters11189473banisters
billeters1136873billeters
bilsteds1134273bil_steds
bimesters1336343bimesters
bisters93922613__bisters
blasters104116143_blasters
blister94415313_blister_
blistery13418713_blistery
blusters104413893_blusters
bolsters103712453bol_sters
canisters112310193canisters
ciliates10413453ciliate_s
cloisters1137433cloisters
clusters102912403_clusters
clysters13227843_clysters
delusters1035983delusters
demisters1249203demisters
diasters92913183di_asters
diesters92513603di_esters
digesters11257883digesters
dilaters92513063dil_aters
diluters9288113dil_uters
disasters1039153disasters
disinters1039713disinters
enlistees954583enlistees
enlister847803enlister_
fainters11349693f_ainters
falters103916473fal__ters
feasters11511563f_easters
feldshers1643093feldshers
felsites1138073felsite_s
festers104121393f__esters
fibster12146533fi_bster_
fidgeters1443623fidgeters
figeaters1345753figeaters
fighters15269403fi_ghters
filchers16286863fil_chers
filers94623723fil___ers
filiate10414233filiate__
filiated12610083filiate_d
filibegs1442223fili_begs
filibuster1551453filibuster_
filigrees1383263filigrees
fillers104320213fil__lers
filmers124211293fil__mers
filmgoers1541983filmgoers
filmsets1353413films_ets
filmsetters1651423filmsetters
filter94517633fil__ter_
filterers12206973filterers
finises10312903finis_e_s
finisher1436303finisher_
finishes1438983finishe_s
finites10315923fini_te_s
fishers134714723f__ishers
fitters104517753f__itters
flashers143912653f_lashers
flatters113814203f_latters
fleshers14339443f_leshers
flichters1774173flichters
flickers17338883f_lickers
fliers94417193f_li__ers
flinders12439263f_linders
flingers123410193f_lingers
flippers15338003f_lippers
flirter10318673f_lirter_
flites95122443f_li_te_s
flitter103413903f_litter_
flivvers1733113f_livvers
floaters112711513f_loaters
flossers11307863f_lossers
flouters11419273f_louters
flushers14279733f_lushers
fluster103913063f_luster_
fluters103713683f_l_uters
flutters114010823f_lutters
foliates11412753foliate_s
foresters12312533foresters
fosters104220103f__osters
friskers15337373f_riskers
fritters113810783f_ritters
fruiters11328183frui_ters
ganisters10248313ganisters
glistens9366593_glistens
glister84013343_glister_
glitters93710543_glitters
gristers94013403_gristers
heisters113413133_heisters
hipsters13268793hi_psters
hoisters113513483_hoisters
holsters113211943hol_sters
insisters997653insisters
jilters144211963jil__ters
keisters123212043_keisters
kiesters123310153ki_esters
kilters113813603kil__ters
klister113410643_klister_
lamisters1157123lamisters
lasters75627693__lasters
leisters83312823_leisters
lifters104313783__lifters
limiters10249333limi_ters
linters73822633__linters
lispers94514323__lispers
listees73416673__listees
listels74212433__listels
listens74014133__listens
lister64527253__lister_
liters65429883__li_ters
litters73422573__litters
lusters73921443__lusters
magisters1235803magisters
maltsters1135193maltsters
meisters103313843_meisters
milters93619093mil__ters
minister10410363minister_
minsters103813923mi_nsters
misinters1138183misinters
misters93927513__misters
molesters1198873molesters
oldsters996733_oldsters
palmisters1444673palmisters
piasters102912813pi_asters
pilaster1038163pilaster_
pilsners1035533pil_sners
pinasters1136823pinasters
plaisters1137813plaisters
plasters103518133_plasters
polishers1477603polishers
pollsters1137173pollsters
registers1038893registers
resisters9310453resisters
rimesters1137483rimesters
roisters83615553_roisters
sinister838583sinister_
sisters73721593__sisters
slitters84014133_slitters
splinters11277923splinters
splitters11307323splitters
tilters73315953til__ters
tipsters10278513ti_psters
twisters11268173_twisters
ulsters72711983_ul_sters
uplifters1463283uplifters
utilisers953553utilis_ers
vilifiers1544563vilifiers
visiters1137413visi_ters
waisters113811523_waisters

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 Filter1786911486410.470380193.6
2DLD Change Limit1486411707.56319653.7
3Display Results1701700.0762236.8
 (SQL Overall)1786911708.10922036.1
 
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.