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

113 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
gavotted136334(None) 
garotted1066191garotted
gavotte1174601gavotte_
gavottes1274181gavottes
cavorted1435692cavorted
garoted9710132garo_ted
garotte868702garotte_
garotter965942garotter
garottes978282garottes
garrotted1164132garrotted
gazetted19234852gazetted
abetted1058323_abetted
aborted10310423_aborted
abutted1056983_abutted
adopted1136253_adopted
allotted986873allotted
averted112211613_averted
aviated11310263_aviated
avoided1235553_avoided
avowed1335953_avo_wed
azoted16388593_azo_ted
batted95623653ba__tted
bedotted1234983bedotted
besotted1135843besotted
blotted103911833_blotted
calotte9510563calotte_
calottes10610083calottes
catted95422473ca__tted
caveated1439133caveated
cavitated15177353cavitated
cavitied14126813cavitied
cavorter1335783cavorter
clotted104011823_clotted
devoted124111093devo_ted
dotted84717523__dotted
facetted1445743facetted
fagoted1236073fago_ted
fatted105419843fa__tted
favored1455983favo_red
favoured1533963favoured
gaited84416923ga__ited
galeated104111573galeated
galette84212693galette_
galettes93111153galettes
galleted1038213galleted
galoped11138063galo_ped
galoshed1334473galoshed
gaoled84814493ga_o_led
garote7717943garo_te_
garotes8614563garo_tes
garotters1055033garotters
garreted1057523garreted
garroted1056783garroted
garrotte965683garrotte_
garrottes1065483garrottes
gasted84821583ga__sted
gated75329773ga___ted
gaveled12399133gav_eled
gavelled13387363gavelled
gavot9321113gavo_t__
gavots1038103gavo_t_s
gavotting1443193gavotting
gazette17357363gazette_
gazettes18296863gazettes
ghosted1236273g_hosted
gitted84015053g__itted
gloated93511533g_loated
glouted9429713g_louted
glutted937243g_lutted
gotten73410113g__otten
gravitated1544133gravitated
gritted94110903g_ritted
grottoed10234503g_rottoed
grouted94111503g_routed
gutted84716363g__utted
hatted104921513ha__tted
havocked2142323havocked
hotted104319933__hotted
jotted143615173__jotted
knotted12357223_knotted
lotted74222403__lotted
matted94521413ma__tted
navette1036983navette_
navettes1136613navettes
patted94724683pa__tted
pivoted1336513pivo_ted
plotted104612373_plotted
potted94624013__potted
ragouted1034423ragouted
ratted74923343ra__tted
repotted1139283repotted
revetted122210943revetted
revolted12319863revolted
revoted114314153revo_ted
rivetted12226083rivetted
rotted74524433__rotted
savored1158343savo_red
savoured1234793savoured
shotted113912383_shotted
slotted84613873_slotted
sotted74121393__sotted
spotted103713133_spotted
stotted83511413_stotted
swotted11398703_swotted
tatted74920533ta__tted
totted74319953__totted
trotted83711283_trotted
undotted1048523undotted
unpotted11108393unpotted
vatted104214733__vatted
vetted104316323__vetted
voted93919143__vo_ted
wotted104115713__wotted

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.1731032896.0
2DLD Change Limit1461621138.67016858.4
3Display Results1131130.0502260.0
 (SQL Overall)1786911138.89320093.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.