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

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

65 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
tacit7633367(None) 
tacet75840021tacet
tact67349031tac_t
acid77533392_acid
act59557842_ac_t
adit56443652_adit
ait38093902_a_it
alit46155692_alit
bait66556002ba_it
cacti9318632cacti
dacite91115882dacite
dacoit9415442dacoit
davit93424592davit
facet106038522facet
facia103218462facia
fact97142542fac_t
gait56150192ga_it
habit103027012habit
licit74327682licit
pact86648722pac_t
racist82822792racist
recit75235102recit
tabid84418252tabid
tace65342512tac_e
taces76237802taces
tach96132752tac_h
tache106222372tache
tachist12613292tachist
tachs105820932tachs
tacitly1236222tacitly
tack106536292tac_k
tacket124627492tacket
tacks115430132tacks
tacky145617442tacky
taco67031352tac_o
tacos77023552tacos
tactic10612752tactic
tacts76524122tacts
tafia84215492tafia
tail45443652ta_il
tain45548072ta_in
taint55542282taint
takin94921302takin
tali46837162tali_
tallit63422732tallit
tamis76728722tamis
tanist6324592tanist
tapir75917062tapir
tapis75028862tapis
tarot55943932tarot
tart47566182ta_rt
tat37690292ta__t
taunt55532282taunt
taut47048962ta_ut
tawie84819812tawie
taxi117124762taxi_
taxis126821972taxis
taxite13511302taxite
tit36771042t__it
toit46353062t_oit
tract75635712trac_t
trait56940842trait
twit76329062t_wit
wait75553692wa_it
yacht13417392yacht

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit53800651.65632487.9
3Display Results65650.0164062.5
 (SQL Overall)178691651.765101241.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.