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

46 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
chevalier174361(None) 
chevaliers1842421chevaliers
cavalier1348172c_avalier
chevalet1658122cheval_et
cavaliers1455613c_avaliers
chalkier1736753ch__alkier
charier124317903ch__arier
cheaper144010583che_a_per
cheapie1437563che_apie_
cheapies1539033che_apies
cheater124816963che_a_ter
cheekier1735103che_ekier
cheerier1348003che_erier
cheesier1335963che_esier
chertier1387873che_rtier
chestier1387423che_stier
chevalets1743383chevalets
chevelure1751743chevelure
chevied16357483chev__ied
chevies153511443chev__ies
chewier1537583che__wier
childlier1543093childlier
chillier13328423ch_illier
chivalries1843963chivalries
chivaried1844053chivaried
chivaries1757433chivaries
cleanlier1143363cleanlier
clerklier1542183clerklier
coalier93416183c__oalier
coevality1745383coevality
creakier14328333cre_akier
creamier12319063cre_amier
creasier103210193cre_asier
crevalle1346163crevalle_
crevalles1455723crevalles
headier113212953_he_adier
healer94221803_he_al_er
heavier13429423_he_avier
lavalier1146043_lavalier
mealier93015903_me_alier
pedalier1137603_pedalier
prevailer1445153prevailer
shalier103116423sh__alier
shellier1138393she_llier
shoalier1137073sh_oalier
vealier102712173_ve_alier

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 Filter1786911486410.1561145455.1
2DLD Change Limit148641467.01621186.0
3Display Results46460.0162875.0
 (SQL Overall)178691467.18824859.6
 
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.