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

209 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
frigates1231093(None) 
frigate11311061frigate_
brigades1236392brigades
ergates8314492er_gates
fixates1737392f_ixates
friges104116482frig__es
frighted1657172frighted
frighten1566442frighten
frightens1655392frightens
frights14339622fright_s
frites94922482fri__tes
fumigates1545572fumigates
irrigates1057252irrigates
ligates82318382_ligates
primates121515932primates
privates131812372privates
urinates8314132urinates
virgates1237922virgates
abrogates12108973abrogates
affricates1844613affricates
agates76121343__agates
agitates9310883agitates
airdates939723airdates
amirates101114793amirates
animates101316423animates
ariettes8411353ariettes
arrogates10129423arrogates
aviates10313063avi_ates
brigade1136493brigade_
brigaded1344573brigaded
brigands1245623brigands
brighten1466243brighten
brightens1565373brightens
brighter1476663brighter
brightest1545663brightest
brights133710233bright_s
bromates12413143bromates
climates12311973climates
crates85736063cr__ates
creates95225203cr_eates
cremates124216003cremates
crinites10612763crinites
derivates13310093derivates
derogates11310973derogates
dilates83220663_dilates
emigrates1248583emigrates
emirates101214853emirates
epilates10313503epilates
ergate7315143er_gate_
fabricates1746463fabricates
fates85139233f___ates
fellates11312753fellates
ferrates113013423ferrates
fiats85324483f_i_at_s
figeater1236953f_igeater
figeaters1345753f_igeaters
fighter143010773f_ighter
fighters15269403f_ighters
fights133816553f_ight_s
figures11239113f_igures
filiates11412663filiates
finales104016013f_inales
finites10315923f_inites
fixate1638733f_ixate_
fixated1835533f_ixated
flighted1646973flighted
flights143310983flight_s
flites95122443fli__tes
fluxgates2042763fluxgates
foggages1434213foggages
folates103218453f_olates
foliates11412753foliates
foredates13310053foredates
formates132814293formates
fornicates1545843fornicates
fracases1336993fracases
frames115119863fr__ames
frater94520593fr__ater
fraters103517213fr__aters
frats86829673fr__at_s
freighted1755203freighted
freighter1655023freighter
freighters1764123freighters
freights1555853freight_s
friaries11310083friaries
friars93812093fri_a_rs
fribbles15287713fribbles
fricatives1844683fricatives
fridges12369483fri_dges
fries85535603fri___es
friezes19418913fri_ezes
frigged13439053frig_ged
fright133715243fright__
frigs96019273frig___s
frijoles1834373frijoles
fringes113514103fri_nges
frisbees13295013frisbees
frisees104411693fri_sees
frises94124273fri__ses
frisettes1295353frisettes
friskets15326263friskets
friths124313583fri__ths
frits86129103fri__t_s
frittatas1241833frittatas
fritted113611333fri_tted
fritter103912773fri_tter
fritters113810783fri_tters
fritts94613193fri__tts
fritzes19329453fri_tzes
frizes184015463fri__zes
frizettes2193493frizettes
frizzes18338183fri_zzes
frizzies19315933frizzies
frizzles19297283frizzles
frogeyes1543743frogeyes
froglets1235263froglets
fromages1437073fromages
frontes104214163fr_ontes
fruitages1344483fruitages
fugatos1135483f_ugatos
fumigate1446153fumigate_
fumigated1644723fumigated
furcates1339883furcates
fustigates1445143fustigates
gates65939513___gates
gradates10510783gradates
grates75429893gr__ates
grimaces1355383grimaces
imitates10310503imitates
ingates82716913_ingates
irrigate967633irrigate_
irrigated1176313irrigated
irritates977223irritates
legates82917683_legates
levigates1346493levigates
ligases82310713_ligases
ligate72519253_ligate_
ligated92414143_ligated
litigates1048003litigates
loricates11310123loricates
marinates112516383marinates
migrates111112853_migrates
mitigates1248253mitigates
muriates10312083muri_ates
navigates1345873navigates
negates83215843_negates
nidates8311893_nidates
obligates12207853obligates
opiates9312143opi_ates
orates64328613or__ates
ordinates1049003ordinates
origamis1145283origamis
origans839973origa_ns
originates1145963originates
oxidates1636333oxidates
pirates93020333_pirates
prates84633163pr__ates
predates11615813predates
pregames1339003pregames
prelates10418573prelates
primages13159273primages
primate111516283primate_
priorates11410763priorates
private121513263private_
privater13158533privater
privatest14196733privatest
probates12414283probates
pronates10418373pronates
prorates10418073prorates
rates55352013_r__ates
rebates95123183_rebates
redates83423873_redates
regales83520793_regales
regrates92618403_regrates
relates73731433_relates
remates93827113_remates
riatas63915093_ri_atas
righted122912143_righted
righter113212383_righter
righters122610713_righters
rightest12149583_rightest
righties12711573_righties
rights104019333_right_s
rites54442553_ri__tes
rivages1138873_rivages
rotates72819773_rotates
rugate75813813_rugate_
ruinates8311883ruinates
seriates82620673seri_ates
striates83417083stri_ates
suricates11311743suricates
tailgates1046533tailgates
triages82613793tri_ages
tribades1136893tribades
tributes1047233tributes
trientes82812123trientes
tziganes1853023tziganes
urates65027763ur__ates
urinate7315363urinate_
urinated9311613urinated
urticates1148893urticates
variates111214983vari_ates
variegates1444043variegates
veritates12310973veritates
virgate1138733virgate_
vulgates12237233vulgates
wriggles13286263wriggles
wrights14318993wright_s
writes94420333wri__tes

Search took 10 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.720248181.9
2DLD Change Limit1461622099.04616157.6
3Display Results2092090.0762750.0
 (SQL Overall)1786912099.84218156.0
 
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.