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

160 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
fossate1038860(None) 
fissate103010031fissate
fossae95510371fossa_e
costate94019272costate
folate93320392fo_late
foliate10513532foliate
formate123115092formate
forsake1436532forsake
fossa85812632fossa__
fossas94610702fossa_s
fosse86119462foss__e
fossette1145262fossette
foveate1338362foveate
roseate7613452roseate
ansate64517863_ansate
apostate1049853apostate
bistate9313823bistate
borate85026153bo_rate
boscage1276533boscage
boskage1465413boskage
bursate94111203bursate
caseate9314783caseate
cassata938143cassata
coesite9713623coesite
cognate10312203cognate
collate92919683collate
comate104124843co_mate
connate9315753connate
cordate10315223cordate
corsage1039803corsage
cossack1545823cossack
cosset84125863cosset_
cosseted1178343cosseted
cossets95014283cossets
costae85319683costa_e
cuspate1138233cuspate
disrate81418523disrate
dissave1139413dissave
donate73619503do_nate
dosage82810003do_sage
dossal75510303dossa_l
dossals8379293dossals
estate64719763_estate
falcate12311613falcate
fasciate1347563fasciate
fate75444283f___ate
fellate10313433fellate
felsite1039083felsite
fermate122813003fermate
ferrate103014043ferrate
fesse86116333fess__e
filiate10414233filiate
fissile10269653fissile
fissure1036783fissure
fixate1638733f_ixate
flossie10337443floss_ie
foggage1334113foggage
foist85730973fois_t_
foisted113210603fois_ted
foists95413983fois_ts
folates103218453fo_lates
foliage1147533foliage
foliated1249913foliated
foliates11412753foliates
fomite113314073fo_mite
footage1148843footage
forage104617003fo_rage
forbade13259103forbade
forbare122310513forbare
foredate12310913foredate
forgat104018583forgat_
forgave1435853forgave
format113021353format_
formates132814293formates
formats123113573formats
forsaken1543353forsaken
forsaker1545103forsaker
forsakes1536893forsakes
forte86131463fo__rte
foss76431643foss___
fosses96022083foss_es
fossettes1245083fossettes
fossick16134733fossick
fossil9379353foss_il
fossils10379013fossils
foster94322223fo_s_ter
fouette1038213fouette
foveae1237563fovea_e
foveated1536293foveated
frigate11311063frigate
furcate12310453furcate
gestate83614073gestate
glossae8477283glossa_e
gossamer1143633gossamer
gossan747233gossa_n
gossans836783gossans
hastate10313913hastate
hessite1038993hessite
horste94817413hors_te
hostage113111233hostage
instate71616483instate
iodate7313503io_date
isolate7313923isolate
lobate82915243lo_bate
locate83919843lo_cate
lysate9388103_lysate
massage1039893massage
message1037833message
messmate1246393messmate
misate81222693_misate
misdate101413963misdate
mismate111415353mismate
misrate91319143misrate
misstate10711343misstate
moschate1546583moschate
moste75925083mo_s_te
notate63217863no_tate
oblate82214743_oblate
oleate6318883_oleate
opiate8513463_opiate
orate55133303_o_rate
ornate6315133_ornate
ossa43714163_ossa__
ossature843303_ossature
outate62923403_outate
ovate84214393_o_vate
passade1039233passade
passage1039803passage
posse74722273poss__e
posset84923253posset_
possets94212773possets
postage103214853postage
postdate1139653postdate
prostate10314533prostate
pulsate9510233pulsate
reslate73520593reslate
restate73824883restate
rosette7310373rosette
rostrate8313843rostrate
rosulate8310903rosulate
rotate63320343ro_tate
sate45556103___sate
sensate7311883sensate
skate94721553__skate
slate55438283__slate
solate64526073so_late
solvate102710213solvate
sorbate9311733sorbate
spate74731583__spate
state56237333__state
testate73916233testate
toccate1138773toccate
togate74515683to_gate
toluate7159343toluate
torsade837593torsade
unstate71916213unstate
upstate91610493upstate
volvate13317993volvate
zoisite1635833zoisite
zonate154114923zo_nate

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.1561145455.1
2DLD Change Limit1340271606.39020974.5
3Display Results1601600.0463478.3
 (SQL Overall)1786911606.59227107.3
 
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.