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 “ecotour” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

64 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
ecotour94436(None) 
ecotours1044461ecotours
colour85915092_colour
contour939972_contour
decolour1185012decolour
ecotone938582ecotone
recontour1143712recontour
acetous9410363acetous
actor71116073ac_to_r
bicolour1243693bicolour
centaur935783centaur
clour76617283_c_lour
color76123743_colo_r
colours95913443_colours
comous10816503_comous
concur10411103_concur
contours1039653_contours
cooer74831013_co_oer
cooter85128613_cooter
copout10418783_copout
cothurn1245053_cothurn
cottar84613813_cottar
cotter84926673_cotter
cutout8315923_cutout
decolor1087033decolo_r
decolours1274413decolours
decorous1138853decorous
detour778193_detour
doctor938993docto_r
dolour75710133_dolour
echoer114011103ec_hoer
ecology13218823ecology
economy1445433economy
ecotage1036883ecotage
ecotonal1046253ecotonal
ecotones1039493ecotones
ecotourism1452533ecotourism
ecotourist1253733ecotourist
ecotype1444843ecotype
editor738663edito_r
emoter85415193emot_er
enamour945433enamour
excitor1645993excito_r
faitour1034883faitour
hector113312653hec_to_r
honour94710863_honour
lector83514983lec_to_r
motor75317293_moto_r
odour64710493__odour
recolor978693recolo_r
recontours1243463recontours
rector84019753rec_to_r
riotous739863riotous
rotor55519733_roto_r
santour737373santour
scooter93312873scooter
scoter83815483scot_er
scotoma1155963scotoma
scour75315533sc__our
secateur1042923secateur
sector83415933sec_to_r
stour54916743__stour
tour45530383___tour
vector113212063vec_to_r

Search took 8 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.406440125.6
2DLD Change Limit134027646.90619407.3
3Display Results64640.0164000.0
 (SQL Overall)178691647.32824384.7
 
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.