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

51 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
clangour1129380(None) 
clangor10426681clango_r
clangours12263121clangours
candour104210242c_andour
clamour1196332cla_mour
clanger104113492clang_er
clangors11417002clangors
clangoured1441622clangoured
languor895422_languor
langur7109302_lang_ur
candor94516423c_ando_r
candours11408643c_andours
cangue91012443c_ang_ue
canoer85121073c_an_oer
cantor85621523c_anto_r
changer134215543chang_er
changeup1642683changeup
chantor123710313chanto_r
clamor1049453cla_mo_r
clamours1255993cla_mours
clang86019313clang___
clanged114212653clang_ed
clangers114312343clangers
clanging124012123clanging
clangored1343653clangored
clangorous1353313clangorous
clangouring1552073clangouring
clangs95113613clang__s
clankier14327083clankier
claqueur19262703claqueur
clinger103812153cling_er
clingier1155853clingier
clour76617283cl___our
congou94313243c_ongou_
congous103615083c_ongous
contour939973c_ontour
crankous1435973crankous
flaneur1034183flan_eur
flanger113412623flang_er
flavour1334633fla_vour
glamour1065133gla_mour
hangout11411393_hangout
labour84210933_la_bour
langue71012173_lang_ue
languors976153_languors
langurs889103_lang_urs
pandour10408213_pandour
playgoer1443533playgoer
rancour987133_rancour
santour737373_santour
slangier9117933slangier

Search took 9 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.440406115.9
2DLD Change Limit146162517.68619016.7
3Display Results51510.0163187.5
 (SQL Overall)178691518.14221946.8
 
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.