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

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

118 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
filets9471895(None) 
filers94623721filers
files85441271file_s
filet85540161filet_
fillets103414751fillets
aglets73915682aglets
aiglets84012912aiglets
bidets95215532bidets
biles75542142bile_s
billets94516152billets
blets75324942_blets
civets115212542civets
culets85518512culets
diets66026642di_ets
facets116316652facets
felts85324542fel_ts
fets75345942f__ets
fiats85324482fi_ats
fibers114717522fibers
fices106031162fice_s
fidgets12388762fidgets
fiefs116213702fi_efs
fields104211042fields
fifers125414922fifers
fifes114822392fife_s
fights133816552fights
filberts1334992filberts
file75446642file__
filed95331902file_d
filer85433002file_r
fileted1159092fileted
fillers104320212fillers
filles94224522filles
fillet95027082fillet_
fillos94415082fillos
fills84632372fil_ls
filmers124211292filmers
filmis114610282filmis
films105617962fil_ms
filmsets1353412filmsets
filos86125382fil_os
fils75838692fil__s
filter94517632filter
filters103816552filters
filth115015822fil_th
filths12389782filths
fines86644262fine_s
finest94321732finest
finless102810782finless
firers94922682firers
fires85740752fire_s
firsts95110922firsts
fists85527542fi_sts
fits76043462fi__ts
fivers124420922fivers
fives116027362five_s
fixers165112982fixers
fixes154723592fixe_s
flats86429742f_lats
fleas86423662f_leas
flees85828752f_lees
fleets96915062fleets
flews115316442f_lews
fleys117015602f_leys
fliers94417192fliers
flies85630712flie_s
fliest94718432fliest
flints95617452flints
flirts95411482flirts
flites95122442flites
flits85625222f_lits
foleys123810462foleys
frets85523402f_rets
fumets114311812fumets
giblets103210422giblets
giglets93211552giglets
gilts64924262gil_ts
gimlets10338432gimlets
hilts86924412hil_ts
ileus54616892_ileus
inlets63915572inlets
islets64513082islets
jilts124717412jil_ts
kilts95122182kil_ts
lets47147942__lets
lilts55822802lil_ts
milers84625162milers
miles74645072mile_s
millets94216842millets
milts75430712mil_ts
oilers64721192oilers
owlets93110392owlets
palets85122312palets
piglets103311792piglets
piles74742612pile_s
pileus84514942pileus
pilots84018872pilots
piolets93513192piolets
pipets105714772pipets
relets64025672relets
riblets93412552riblets
riles55343642rile_s
rillets74216152rillets
rivets94417112rivets
silents73514492silents
silts55330822sil_ts
tilers63523502tilers
tiles55542102tile_s
tilts55325612til_ts
toilets74112912toilets
valets93715622valets
vilest9416842vilest
violets102210002violets
wiglets113411422wiglets
wiles85437872wile_s
willets104414322willets
wilts85023502wil_ts
zibets1737742zibets

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit825511182.26336478.6
3Display Results1181180.0333575.8
 (SQL Overall)1786911182.65667278.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.