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

74 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
cheviot154693(None) 
cheviots1643781cheviots
chariot12316212chariot
chemist143615002chemist
cheroot12413692cheroot
chevied16357482chevied
chevies153511442chevies
chevret153310632chevret
chevron1575782chevron
heriot9422342_heriot
challot123613263challot
chalot113020133ch_alot
chariots1339393chariots
cheapo134810083cheapo_
cheapos14418513cheapos
cheat105732453che__at
checkout1945593checkout
chedite1338863chedite
cheerio12379313cheerio_
cheerios13317583cheerios
cheero114712933cheero_
cheeros123711633cheeros
chefdom18134073chefdom
chefing16359033chefing
chegoe1237273che_goe
cheloid13310833cheloid
chemic153012093chemi_c
chemics16349583chemics
chemise143211503chemise
chemism16339303chemism
chemists152710323chemists
chemo12313633che_mo_
chemos13311723che_mos
cherish15310463cherish
cheroots1348193cheroots
chert105232103che__rt
chervil1534953chervi_l
chervils1644553chervils
chest104926143che__st
chevalet1658123chevalet
cheveron1645263cheveron
chevre14318313chev_re
chevres15379793chevres
chevrets16255323chevrets
chevrons1665463chevrons
chevy16479993chev__y
chevying2034053chevying
chewier1537593chewier
chewiest16177293chewiest
chewing163911143chewing
chewink19315113chewink
chit96937463ch__i_t
chivied16368383chivied
chivies153412853chivies
chorion12311773chorion
chutist1239453chutist
chymist17268173chymist
clevis1158963clevi_s
coedit9316243coedi_t
coexist1638583coexist
cohesion1347283cohesion
convict143410983convict
credit9315193credi_t
crevice1436153crevice
evict104417143__evict
havior1248203_havior
heist87030913_he_ist
helio85321193_helio_
helios94816633_helios
helot85332683_he_lot
heriots10312063_heriots
preriot9316413preriot
sheroot10414373sheroot
theist9314763the_ist

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 Filter1786911340270.420425454.8
2DLD Change Limit134027747.22018563.3
3Display Results74740.0332242.4
 (SQL Overall)178691747.67323288.3
 
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.