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

81 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
chiffon184405(None) 
chiffons1943691chiffons
chignon1344622chignon
chiton112612392chi_ton
griffon1443102griffon
biffin14369103_biffin
caisson936593caisson
chaff165016283chaff__
chaffed19387703chaffed
chaffer18389473chaffer
chaffing2036323chaffing
chaffs17459613chaff_s
chaffy20456473chaff_y
chamfron1844493chamfron
chanfron1644803chanfron
chanson1238043chanson
chefdom18134073chefdom
cheffed19335863cheffed
cheffing2034463cheffing
chevron1575783chevron
chiao105618363chi_ao_
chicano1496873chicano
chicken18278983chicken
chico124218253chi_co_
chicos134614833chi_cos
chidden14255223chidden
chief134419483chief__
chiefdom1942483chiefdom
chiefer1536863chiefer
chiefly1834103chiefly
chiefs14509653chief_s
chiffonade2261453chiffonade
chiffonier2151503chiffonier
chignons1444713chignons
chigoe1237533chi_goe
chin96934743chi___n
chinbone1555163chinbone
chino105823313chi_no_
chinone12510163chi_none
chinook1675103chinook
chinos115018693chi_nos
chiro105320343chi_ro_
chiros114617773chi_ros
chirren12388743chirren
chitin113114963chi_tin
chitlin12269283chitlin
chitons122611913chi_tons
chon96627793ch___on
chorion12311773chorion
chrismon1544643chrismon
chronon1237353chronon
chuff164812493chuff__
chuffed19316643chuffed
chuffer18337143chuffer
chuffing2055043chuffing
chuffs17427783chuff_s
chuffy20445863chuff_y
cion613330923c_i__on
citron83112983c_itron
cliff135917133cliff__
cliffs14477593cliff_s
cliffy17435243cliff_y
coffin14339813c_offin
coiffe1447043coiff_e
coiffed1635413coiffed
coiffes1546803coiffes
coiffing1755933coiffing
coition9314313coition
crimson1135643crimson
griffin1434513griffin
griffons1542573griffons
shippon14285803shippon
stiffen13286023stiffen
tiffin12327933_tiffin
whiff17310063whiff__
whiffed2064473whiffed
whiffer19105323whiffer
whiffet1965343whiffet
whiffing2134703whiffing
whiffle1933533whiffle
whiffs1835083whiff_s

Search took 7 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 Limit134027816.45320769.7
3Display Results81810.0302700.0
 (SQL Overall)178691816.88925938.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.