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

42 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
czardases214303(None) 
carcases12313082c_arcases
cardcases1446492c_ardcases
charases131312762char_ases
czardas1934672czarda__s
acariases1146613acariases
arrases71214543__arrases
caddises12329353c_addises
camases114216343c_a_mases
canvases13349513c_anvases
capiases1239253c_apiases
carafes125015703c_ar_afes
carates95630613c_ar_ates
carcase11312733c_arcase_
carcass11310513c_arcas_s
carcasses1337473c_arcasses
cardcase1345963c_ardcase_
caresses10314063c_aresses
carfares13310323c_arfares
caritases1139743c_aritases
carnages11312213c_arnages
carouses10614503c_arouses
carses85233653c_ar__ses
cartages11313313c_artages
carwashes1745773c_arwashes
caseases10410473c_aseases
caudates11310263c_audates
charades141310853char_ades
chordates1547683chordates
cordages12310113c_ordages
crases85532313c__r_ases
creases94020963c__reases
czardoms2243743czard_oms
czarisms2155753czar_isms
czarists1966223czar_ists
gearcases1254693gearcases
giardiases1242323giardiases
hardass1139753_hardas_s
hardasses1346453_hardasses
madrases112610003_madrases
teargases1044803teargases
yardages1336203_yardages

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641428.84316808.9
3Display Results42420.0162625.0
 (SQL Overall)178691429.03219784.2
 
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.