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 “chivvies” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

104 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
chivvies195442(None) 
chivies153412851chi_vies
chivvied2052521chivvied
civvies1555841c_ivvies
chevies153511442ch_evies
chilies124218302chi_lies
chillies134113472chillies
chippies17309752chippies
chitties13310772chitties
chivaries1757432chivaries
chives144317592chi_v_es
chivied16368382chi_vied
civies114116442c_i_vies
divvies1457662_divvies
skivvies18112882skivvies
achieves1645523achiev_es
bhisties1339003bhisties
cavies114525003c__avies
cavities131412613cavities
challies133915633challies
chammies172910153chammies
chanties132615803chanties
chappies172610093chappies
charlies133414223charlies
cheapies1539033cheapies
cherries131812973cherries
chervils1644543chervils
chevied16357483ch_evied
chevres15379793ch_evres
chiauses1336483chiauses
chicanes1559373chicanes
chichier1836023chichier
chichiest1936343chichiest
chichis1737073chichi_s
chickees19258513chickees
chicles143512503chi_cles
chicories1688763chicories
chides124620473chi__des
chigoes1338353chi_goes
childes134211273chi_ldes
chiles115425303chi__les
chilis115517873chi_li_s
chillier13328423chillier
chilliest14358913chilliest
chillis124411603chilli_s
chimblies1845023chimblies
chimeres153511303chimeres
chimes134922573chi__mes
chinches18369363chinches
chines115029173chi__nes
chinkier17377363chinkier
chinkiest1867023chinkiest
chinones13510473chinones
chintses1337113chintses
chintzes2235963chintzes
chippie16297693chippie_
chippier17297673chippier
chippiest18256803chippiest
chirpier15276303chirpier
chirpiest16286473chirpiest
chirres123812253chi_rres
chitins122713793chi_tins
chitlins13289393chitlins
chivalries1843963chivalries
chivaree1646363chivaree
chivarees1744383chivarees
chivaried1844053chivaried
chive135117623chi_v_e_
chivvy20374433chivv__y
chivvying2441713chivvying
chivying2034973chivying
christies1449263christies
chuckies1937703chuckies
cissies94116153c_issies
cities84524853c_i_ties
civics13397823c_i_vics
civie103716353c_i_vie_
clivias1266693cli_vias
divvied1544813_divvied
ghillies12408663ghillies
heavies132713873_heavies
hickies163614743_hickies
hinnies103615103_hinnies
hippies142813743_hippies
hissies103915823_hissies
hives116925513_hi_v_es
ivies84215753__i_vies
navvies1335323_navvies
privies122414263pri_vies
savvies1337603_savvies
shavies134213203sh_avies
shimmies15287803shimmies
shindies122610503shindies
shinnies113010913shinnies
shives124921413shi_v_es
skivvied1971813skivvied
thieves1346903thiev_es
thirties1139723thirties
whimsies1635193whimsies
whinnies14237273whinnies
whirlies14167373whirlies
whirries14136693whirries
whiskies1835953whiskies
whities133113253whi_ties

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.1731032896.0
2DLD Change Limit1461621048.17317883.5
3Display Results1041040.0462260.9
 (SQL Overall)1786911048.39221293.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.