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

80 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
contessa104458(None) 
contessas1145021contessas
confess12399902confess_
contes84432912conte_s_
contest93523232conte_st
contests103413382contests
countess103710042countess_
canters94827723canters_
centers94420593centers_
centeses1079443centeses
centesis1058143centesis
coatees93816533coatees_
coaters93525773coaters_
coatless1039693coatless_
cointers103616403cointers_
colters93522433colters_
comtes106222813comte_s_
concuss1138063concuss_
condense1179613condense
cones76457423con_e_s_
coneys115218423con_eys_
confers124120093confers_
conferva1644433conferva
confessed1546053confessed
confesses1438623confesses
confessor1444343confessor
congees103517923congees_
congers104223233congers_
conges94928173conge_s_
congest104618773conge_st
congests113510383congests
congress1138073congress_
conies84338593conie_s_
conkers133721043conkers_
conners94023113conners_
contagia1156773contagia
conte76633203conte___
contemn1137803conte_mn
contemns1237403contemns
contempo1444833contempo
contempt1447473contempt
contend103511893conte_nd
contends112810573contends
content94326153conte_nt
contents104018213contents
contestant1269933contestant
contested12310693contested
contester11311183contester
context163913433conte_xt
contexts17378653contexts
continua1047653continua
contos84923233cont_os_
contra83314693cont__ra
contras93015603contras_
contrast102614783contrast
contuse9311413cont_use
contused1138443contused
contuses10413453contuses
converse13310263converse
converso1336423converso
conveys15308223conveys_
cooters94525713cooters_
copters113621273copters_
costers94128303costers_
costless10310003costless_
cotes76347843co_te_s_
cotters94323433cotters_
counters103320183counters_
countesses1248843countesses
countless1146373countless_
couters93827283couters_
coxless1637743coxless_
coyness1277323coyness_
hostess103210233hostess_
hotness1038603hotness_
mantissa1044573mantissa
montes84226933monte_s_
poetess938933poetess_
pontes83627853ponte_s_
sonless72612613sonless_

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.1561145455.1
2DLD Change Limit146162809.43615489.8
3Display Results80800.0302666.7
 (SQL Overall)178691809.62218571.1
 
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.