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

130 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
tristate831102(None) 
aristate8312121aristate
cristate10310591cristate
aristae7312522arista_e
bistate9313812_bistate
crispate1246912crispate
cristae9310602crista_e
cristated1247412cristated
pristane10310332pristane
prostate10314532prostate
restate73824872_restate
testate73916232t_estate
tractate10411002tractate
triptane1047562triptane
triste63818642tris__te
agitate8312063agi_tate
antistate9410143antistate
apostate1049853apostate
ariette7312373ariet_te
arillate8412993arillate
arista6415293arista__
aristas7413523arista_s
bristle91910103brist_le
costate94019273_costate
crispated1445023crispated
crista8311803crista__
dictate10311663_dictate
disrate81418523_disrate
distaste939943_distaste
driftage1342933driftage
eructate1047333eructate
estate64719763__estate
fissate103010033_fissate
frigate11311063fri_gate
frisette1195483frisette
frittata1142833frittata
frustrate1245583frustrate
gestate83614073_gestate
grisette994653grisette
gristle8169223grist_le
hastate10313913_hastate
hesitate1169973hesitate
imitate9310873imi_tate
instate71616473_instate
intrastate1055713intrastate
irritate867873irritate
ministate1147263ministate
misate81222693_mis_ate
misdate101413963_misdate
mismate111415353_mismate
misrate91319143_misrate
misstate10711333misstate
mistake131312613_mistake
nictate9310223_nictate
orientate946513orientate
outstate81411993outstate
primate111516283pri_mate
priorate10411733priorate
pristanes11410423pristanes
pristine10313503pristine
private121513263pri_vate
prostates11314423prostates
prostrate11412483prostrate
reinstate948883reinstate
reslate73520593_reslate
restage83316183_restage
restated93120173_restated
restates83423413_restates
roseate7613453_roseate
rostrate8313833_rostrate
rotate63320343_r_otate
state56237333___state
striate74218953stri__ate
substate101711083substate
tailgate946813tailgate
testae64216253t_esta_e
testates83615443t_estates
thionate11137493thionate
thistle10107803thist_le
tisane6311573t_is_ane
titrate72215573t_itrate
trabeate1049483trabeate
tractates1159753tractates
translate9412273translate
trestle72611363trest_le
triacetate1263543triacetate
triage72812893tri__age
tribade1037283tri_bade
tribulate1148083tribulate
tribunate1144953tribunate
tribute937313tri_bute
trichite1349333trichite
trijugate1743243trijugate
trilobate1145433trilobate
triphase1346193triphase
triplane1039113triplane
triplite1039103triplite
triptan947543tripta_n
triptanes1147463triptanes
triptans1047363triptans
triscele1045433triscele
trisect939733trisect_
trisected1244913trisected
trisects1035983trisects
triseme936543tris_eme
trishaw1344753trisha_w
trishaws1444003trishaws
triskele1244573triskele
trisome9310223tris_ome
tristeza1742933tristeza
tristful1144923tristful
tristich1348423tristich
trite54730033tri___te
tritiated1047523tritiated
tritone73613883tri_tone
triturate947483triturate
troostite944723troostite
truncate1046283truncate
trustable1147123trustable
trustee73514443trust_ee
tryste9399583trys__te
tungstate1042863tungstate
turista737443turista__
turistas846693turista_s
twistable1444273twistable
unstate71916213_unstate
upstate91610493_upstate
urinate7315363uri_nate
vittate10409723_vittate
wristlet1138643wristlet

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.1731032896.0
2DLD Change Limit1461621308.89316435.6
3Display Results1301300.0433023.3
 (SQL Overall)1786911309.10919617.0
 
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.