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

91 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
chignon134462(None) 
chignons1444711chignons
chiffon1844052chiffon
chignoned1643002chignoned
chigoe1237532chig_oe
chino105823312chi_no_
chinone12510162chi_none
chinos115018692chi_nos
chiton112612392chi_ton
chronon1237352chronon
mignon937952_mignon
actinon9459463acti_non
caisson936593caisson
cannon84514443c_annon
canon74725303c__anon
chagrin1337893chagrin
champignon20171433champignon
chanson1238043chanson
chegoe1237273cheg_oe
chevron1575783chevron
chianti1236613chianti
chiao105618363chi_ao_
chicano1496873chicano_
chicanos1595993chicanos
chicken18278983chicken
chico124218253chi_co_
chicos134614833chi_cos
chidden14255223chidden
chiffons1943693chiffons
chigger1436003chigger
chigoes1338353chigoes
chimney1795483chimney
chin96934743chi___n
china105022483chi_n_a
chinas115119403chi_nas
chinbone1555163chinbone
chinch163911243chi_nch
chine105231723chi_n_e
chined125620063chi_ned
chines115029173chi_nes
chining133316843chi_ning
chink145321593chi_n_k
chinks155817573chi_nks
chinky185610543chi_nky
chinned134810503chinned
chinning14329653chinning
chinones13510483chi_nones
chinook1675103chinook
chins105631463chi_n_s
chints115117833chi_nts
chintz204212033chi_ntz
chiro105320343chi_ro_
chiros114617773chi_ros
chirren12388743chirren
chitin113114963chi_tin
chitlin12269283chitlin
chitons122611913chitons
chon96627793ch___on
chorion12311773chorion
chrismon1544643chrismon
chronons1347353chronons
cion613330923c_i__on
citron83112983c_itron
cogon89120903c_og_on
coign85013913coig__n
coigne94612193coign_e
coigned11418663coigned
coignes103912153coignes
coigning1237183coigning
coigns94410063coign_s
coition9314313coition
crimson1135643crimson
epigon937963epig_on
hagdon1188283_hagdon
lignan75510323_lignan
lignin74911193_lignin
lorgnon844423lorgnon
mignons1037863_mignons
ninon55517383_ni_non
phonon114012033ph_onon
pigeon949413_pigeon
pinon76024533_pi_non
rhino84614323rhi_no_
rhinos94411123rhi_nos
shippon14285803shippon
signor73510353_signor
thionin1048673thionin
tiglon737923_tiglon
tigon63914443_tig_on
trigon74513103trig_on
wigeon1037223_wigeon

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 Filter1786911340270.406440125.6
2DLD Change Limit134027917.90616952.6
3Display Results91910.0303033.3
 (SQL Overall)178691918.34221420.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.