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

106 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
federals124730(None) 
federal1148531federal_
falderals13104042falderals
federacy1744242federacy
federalese1452312federalese
federalism1644912federalism
federalist1446442federalist
federally1645292federally
federate12310882federate
federates13310152federates
fedoras1137922fedora_s
ferals94216642f__erals
funerals1146452funerals
generals9109332generals
ruderals946072ruderals
severals1137592severals
bedells10379363bede_lls
bedels94015273bede__ls
bedevils1444373bedevils
bedrails1136293bed_rails
ceders93817673ceder__s
centrals102712033centrals
cereals9313173cere_als
cerebrals1354833cerebrals
deals65435343__de_als
decals93717713__decals
deferrals1343683deferrals
derails84216393__derails
derats74625063__derats
derays105514253__derays
deverbals1544103deverbals
edemas9310503_edema_s
emerald1046923_emerald
emeralds1144593_emeralds
eternals8238953_eternals
faders105117463fader__s
falderal12104803falderal_
falderols13103883falderols
fecials123510333fe_cials
federacies1644993federacies
federaleses1552303federaleses
federalisms1764403federalisms
federalists1544753federalists
federalize2345823federalize
federalizes2445173federalizes
federated1438423federated
federator1346263federator
federators1446193federators
fedexes1835473fede_xes
fedora1038593fedora__
feedbags1592733feedbags
feeders113712863feeder__s
feels85223043fe_e__ls
femoral1238723femoral_
fenders113717263fender__s
feral85424653f__eral_
ferrels10248623fe_rrels
fetials103711743fe_tials
feverous1446513feverous
fevers125414893fever__s
fewtrils1443203fewtrils
florals104210063f_lorals
folderols13103663folderols
funeral1037623funeral_
general81010933general_
gomerals1147443gomerals
heders104119763heder__s
humerals1347173humerals
ideals75012503_ide_als
laterals8312753laterals
liberals1039413liberals
literals8312293literals
medals94218053med__als
medevacs1643373medevacs
medials103914733med_ials
medicals1349363medicals
medievals1553353medievals
minerals10311373minerals
neutrals846283neutrals
numerals1047333numerals
oedemas1056693oedema_s
ordeals877993orde_als
pedals94316033ped__als
pederast1158593pederast
pederasts1255203pederasts
pedestals1255203pedestals
pedocals1346083pedocals
peytrals1355493peytrals
redears82814453rede_ars
redials84416883red_ials
redraws11218473red_raws
redreams1195953redreams
referrals1243493referrals
renewals1137273renewals
repeals94014523repe_als
reseals73917663rese_als
reveals103812723reve_als
reversals1245203reversals
ruderal837373ruderal_
seders74420283seder__s
several1039533several_
telerans859473telerans
ventrals112910003ventrals
vesperals1443933vesperals
veterans1148853veterans
wedels103811033wede__ls

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.500357382.0
2DLD Change Limit1461621067.48319532.5
3Display Results1061060.0462304.3
 (SQL Overall)1786911068.02922255.7
 
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.