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

126 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
filarees118764(None) 
filagrees1373881filagrees
filaree10611211filaree_
filagree1295172filagree_
filagreed1472872filagreed
filigrees1383262filigrees
fillagrees1452582fillagrees
flares94521702f_lar_es
larees65323112__larees
bidarkees1642143bidarkees
bilayers13296923bilayers
binaries10314183binaries
bizarres1953793bizarres
blares85021633_blar_es
chivarees1744383chivarees
cicorees1246413cicorees
cigarets1145473cigarets
clarets94111103_clarets
claries93422203_claries
claroes93113733_claroes
diaries83321953di_aries
dilaters92513063dilaters
dilates83220663dila_tes
disagrees1146403disagrees
enlarges946073enlarges
failures1135163failur_es
falafels1453113falafels
farces115223323f__arces
farers95924053f__arers
fares85852873f__ar_es
farles96025783f__arles
fearers104815273f_earers
felafels1452853felafels
fiacres1237253fi_acres
fiancees1335103fiancees
fiances12310673fi_ances
fiars86720833fi_ar__s
fibres114312123fi_br_es
figurers12254873figurers
figures11239113figur_es
filament13410033filament
filaments1446653filaments
filar84819293filar___
filaria1039653filar_ia
filariae1148473filariae
filarial1147863filarial
filarian1148313filarian
filariases1343983filariases
filariid1244033filariid
filariids1342533filariids
filatures1245853filatures
filberts1334993filberts
filchers16286863filchers
filches153410723fil_ches
filers94623723fil__ers
files85441273fil___es
filets94718953fil__ets
filiates11412663filiates
filibegs1442223filibegs
filigree1264663filigree_
filigreed1482443filigreed
fillagree1343623fillagree_
fillagreed1541753fillagreed
fillers104320213fil_lers
filles94224523fil__les
fillets103414753fil_lets
fillies103420253fil_lies
filmers124211293fil_mers
filmless1344553filmless
filmsets1353413filmsets
filtered12259043filtered
filterer11258143filterer
filterers12206973filterers
filters103816553fil_ters
filtrates1247733filtrates
finagles12237553finagles
finales104016013fina_les
finances1338653finances
fineries112416743fineries
firers94922683fi__rers
fires85740753fi__r_es
fixates1737393fixa_tes
fixures17596063fixur_es
flakers143613273f_lakers
flakes134118873f_la_kes
flambes14419503f_lambes
flamens124611063f_lamens
flamers124616363f_lamers
flames114723693f_la_mes
flanes94522423f_la_nes
flanges113413273f_langes
flare84823633f_lar_e_
flared105317603f_lar_ed
flareup1243173f_lareup
flareups1342473f_lareups
flashes133916103f_lashes
flaxes165015353f_la_xes
flayers133912033f_layers
flees85828753f_l__ees
florets1039853f_lorets
folates103218453fola_tes
frees86131393f___rees
friaries11310083friaries
gisarmes1144433gisarmes
glares75518863_glar_es
hirees95117293hi__rees
imarets9138643_imarets
killdees1373963killdees
laree56036293__laree_
lares54852633__lar_es
larges74824233__larges
miladies1139923miladies
milages103114403mila_ges
milreis937323mil_reis
minarets1048843minarets
pugarees11195493pugarees
salaries8319573salaries
sarees65329943__sarees
shikarees1643073shikarees
shivarees1543953shivarees
silages82514443sila_ges
silanes72517163sila_nes
sirees64624583si__rees
sirrees73410573si_rrees
vilayets1443073vilayets
vivaries1439263vivaries

Search took 7 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.1561145455.1
2DLD Change Limit1461621266.48622535.0
3Display Results1261260.0632000.0
 (SQL Overall)1786911266.70526650.4
 
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.