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

253 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
frigate1131106(None) 
frigates12310931frigates
brigade1136492brigade
ergate7315142er_gate
fixate1638732f_ixate
fright133715242fright_
frighted1657172frighted
frighten1566442frighten
frights14339622frights
fumigate1446152fumigate
irrigate967632irrigate
ligate72519252_ligate
primate111516282primate
private121513262private
rugate75813812_rugate
urinate7315362urinate
virgate1138732virgate
abrogate11129603abrogate
affricate1744973affricate
agate66525153__agate
agitate8312063agitate
airdate8311323airdate
amirate91115953amirate
animate91617213animate
arcuate9311963arcuate
ariette7312373ariette
aright103817663aright_
arillate8412993arillate
aristae7312533aristae
aristate8312133aristate
arrogate91210323arrogate
aviate9315203avi_ate
binate8419773_binate
bregmate1345533bregmate
brigaded1344573brigaded
brigades1236393brigades
brigand1136643brigand
bright124215923bright_
brighten1466243brighten
brighter1476663brighter
brights133710233brights
bromate11313553bromate
carinate103320253carinate
cirrate92413493cirrate
climate11312833climate
crate76537403cr__ate
create85126383cr_eate
cremate113816183cremate
crenate93317113crenate
crinite9513633crinite
crispate1246913crispate
cristae9310613cristae
cristate10310603cristate
derivate12311203derivate
derogate10311353derogate
dilate73220693_dilate
emigrate1149603emigrate
emirate91015833emirate
epilate9314283epilate
ergates8314493er_gates
fabricate1646833fabricate
falcate12311623falcate
fate75444283f___ate
fellate10313433fellate
feriae95618603feri_a_e
fermate122813003fermate
ferrate103014043ferrate
fiat76646643f_i_at_
fiats85324483f_i_ats
figeater1236953f_igeater
fight124027093f_ight_
fighter143010773f_ighter
fights133816553f_ights
figurate1237193f_igurate
figure10258833f_igure
filiate10414233filiate
finale94116763f_inale
finite9316823f_inite
fissate103010033fissate
fixated1835533f_ixated
fixates1737393f_ixates
flight134014813flight_
flighted1646973flighted
flights143310983flights
flighty17347433flighty
flite85424963fli__te
fluxgate1942893fluxgate
foggage1334113foggage
folate93320393f_olate
foliate10513533foliate
foredate12310913foredate
forficate1745123forficate
forgat104018583forgat_
forgave1435853forgave
formate123115093formate
fornicate1446083fornicate
fossate10388603fossate
foveate1338363foveate
frae75330473fr__a_e
fragile1147843fragile
frame105821803fr__ame
frat75648543fr__at_
frater94520593fr__ater
frats86829673fr__ats
freight1447603freight_
freighted1755203freighted
freighter1655023freighter
freights1555853freights
friable122612563friable
friar85414273fri_a_r
friars93812093fri_ars
friary124010093fri_ary
fribble14287783fribble
fricative1746743fricative
fridge11379253fri_dge
frieze18378143fri_eze
frig85424503frig___
friges104116483frig_es
frigged13439053frigged
frightens1655393frightens
frigid1136923frig_id
frigs96019273frig__s
frijole1734583frijole
fringe104013953fri_nge
frisbee12298513frisbee
frise85322453fri__se
frisee94217993fri_see
frisette1195483frisette
frisket143811773frisket
frit77044473fri__t_
frites94922483fri__tes
frith115922033fri__th
frits86129103fri__ts
fritt86129413fri__tt
frittata1142833frittata
fritted113611333fri_tted
fritter103912773fri_tter
fritts94613193fri_tts
fritz176020773fri__tz
frizette2093503frizette
frizzle18367043frizzle
frogeye1443813frogeye
froglet11310063froglet
fromage1336753fromage
frugal1036393fruga_l
fruitage1244343fruitage
fugato1036223f_ugato
fumigated1644723fumigated
fumigates1545573fumigates
furcate12310453furcate
fustigate1345623fustigate
gate55746573___gate
gradate9511233gradate
grate64932883gr__ate
grimace1255083grimace
imitate9310873imitate
ingate73018243_ingate
irate55627983__irate
irrigated1176313irrigated
irrigates1057253irrigates
irritate867873irritate
jugate14379463_jugate
legate72917453_legate
levigate1246623levigate
ligase7259913_ligase
ligated92414143_ligated
ligates82318383_ligates
litigate948303litigate
loricate10310663loricate
marinate103017783marinate
migrate101314173_migrate
misate81222693_misate
mitigate1148693mitigate
muriate9313363muri_ate
muricate12311113muricate
navigate1246073navigate
negate72915573_negate
nidate7313783_nidate
obligate11198303obligate
opiate8513463opi_ate
orate55133303or__ate
ordinate9310253ordinate
origami1045453origami
origan7310693origa_n
origans839973origans
originate1047023originate
ornate6315143or_nate
oxidate1537023oxidate
pirate82322883_pirate
plicate11314513plicate
prate75135983pr__ate
predate10616893predate
pregame1239553pregame
prelate9519693prelate
primage12169143primage
primates121515933primates
priorate10411733priorate
privater13158533privater
privates131812373privates
probate11414483probate
prolate9419793prolate
pronate9418873pronate
prorate9418733prorate
quinate16511573quinate
ramate83921693_ramate
rate45458763_r__ate
rebate84424113_rebate
redate74124683_redate
regale74821453_regale
regave104713383_regave
regrate82618663_regrate
relate64033633_relate
remate84428683_remate
riata54618023_ri_ata
right94430503_right_
righted122912143_righted
righter113212383_righter
righto104111093_righto
rights104019333_rights
righty135011833_righty
rite45849453_ri__te
rivage1038843_rivage
rotate63320343_rotate
rugae65114763_ruga_e
ruinate7312833ruinate
seriate73722473seri_ate
sigmate10710143_sigmate
spicate113214193spicate
spinate93114813spinate
striate74218953stri_ate
suricate10312613suricate
tailgate946823tailgate
togate74515683_togate
triage72812893tri_age
tribade1037293tribade
tribute937313tribute
trijugate1743243trijugate
tristate8311033tristate
triste63818643tri_ste
trite54730033tri__te
tzigane1742943tzigane
urate55432163ur__ate
urinated9311613urinated
urinates8314133urinates
urticate1049863urticate
variate101316433vari_ate
variegate1344103variegate
virgates1237923virgates
vulgate11388433vulgate
wriggle12316213wriggle
wright133713513wright_
wrights14318993wrights
write85522833wri__te

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 Filter1786911340270.403443402.0
2DLD Change Limit1340272536.36021073.4
3Display Results2532530.0962635.4
 (SQL Overall)1786912536.85926052.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.