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

220 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
chippies1730975(None) 
chappies172610091chappies
chippie16297691chippie_
chippier17297671chippier
chippiest18256801chippiest
hippies142813741_hippies
chappie16298652chappie_
cheapies1539032cheapies
chilies124218302chi_lies
chillies134113472chillies
chipped174110812chipp_ed
chipper163912582chipp_er
chippers173510872chippers
chipping18389792chipping
chirpier15276302chirpier
chirpiest16286472chirpiest
chitties13310772chitties
chivies153412852chi_vies
chivvies1954422chivvies
choppier17286642choppier
choppiest18226372choppiest
crappies142911152crappies
cripples14298402cripples
croppies143111132croppies
hippie132811242_hippie_
hippier143212102_hippier
hippiest152611612_hippiest
whippier18265822whippier
whippiest19265112whippiest
yippies14279292_yippies
bhisties1339003bhisties
buppies133011063_buppies
canopies12311853canopies
challies133915633challies
chammies172910153chammies
chanties132615803chanties
chapes135421873ch_ap_es
chapped172711443chapp_ed
chapping183710723chapping
charlies133414223charlies
cheapie1437563cheapie_
cherries131812973cherries
chevies153511443ch_evies
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
chimps155713663chimp__s
chinches18369363chinches
chines115029173chi__nes
chinkier17377363chinkier
chinkiest1867023chinkiest
chinones13510473chinones
chintses1337113chintses
chintzes2235963chintzes
chipotles1643793chipotles
chippered1945003chippered
chippy18437613chipp__y
chips125721253chi_p__s
chirped15379783chirp_ed
chirper14359963chirp_er
chirpers15358133chirpers
chirpily1843773chirpily
chirping16278863chirping
chirps135414003chirp__s
chirres123812253chi_rres
chitins122713793chi_tins
chitlins13289393chitlins
chivaries1757433chivaries
chives144317593chi__ves
chivied16368383chi_vied
chivvied2052523chivvied
chopines152711733chopines
chopins142312243ch_opins
chopped174511003chopp_ed
chopper163611893chopp_er
choppers174110453choppers
choppily2044133choppily
choppiness1973563choppiness
chopping183710263chopping
christies1449263christies
chuckies1937703chuckies
chuppahs2042073chuppahs
chuppas1644123chupp_as
cissies94116153c_issies
cities84524853c_i_ties
civies114116443c_i_vies
civvies1555843c_ivvies
clipped14439833clipp_ed
clipper133710323clipp_er
clippers14368833clippers
clipping15349153clipping
clippings16273753clippings
complies14314523complies
copies104130303c__opies
coppices1638243c_oppices
cowpies143314283c_owpies
crappie13298983crappie_
crappier14288133crappier
crappiest15267263crappiest
creepies1239613creepies
crimpier14287323crimpier
crimpiest15237183crimpiest
crimples14308963crimples
cripes105120873cri_p_es
cripple13378583cripple_
crippled15336793crippled
crippler14826713crippler
cripplers15314993cripplers
crispier12297253crispier
crispiest13197423crispiest
croppie13278793croppie_
cuppier1368323c_uppier
cuppiest1448193c_uppiest
dippier123111393_dippier
dippiest132511133_dippiest
drippier1385043drippier
drippiest1445363drippiest
fipples14298653_fipples
floppies1546813floppies
ghillies12408663ghillies
gipsies1039903_gipsies
grippes124810373gripp_es
grippier1355203grippier
grippiest1435143grippiest
guppies123310523_guppies
happier143312033_happier
happiest152411673_happiest
harpies123818313_harpies
hickies163614743_hickies
hinnies103615103_hinnies
hiplines13310583_hiplines
hipped144317693_hipp_ed
hipper133818023_hipp_er
hippest14219753_hipp_est
hippieish1941843_hippieish
hippiness1635463_hippiness
hipping153915103_hipping
hippish1736183_hippish
hippos13408433_hipp_os
hirples12149643_hirples
hissies103915823_hissies
hoppier143110703_hoppier
hoppiest152610723_hoppiest
hopples142810713_hopples
koppies153210013_koppies
lippier112710573_lippier
lippiest122310613_lippiest
nappies114613393_nappies
nippier11319833_nippier
nippiest12279973_nippiest
nipples11319663_nipples
pappies103214823_pappies
pippins10319753_pippins
poppies102816193_poppies
preppies1149673preppies
puppies103212613_puppies
quippier2133773quippier
quippiest2243983quippiest
ripples113513293_ripples
schappes1736033schapp_es
sharpies13411223sharpies
shimmies15287803shimmies
shindies122610503shindies
shinnies113010913shinnies
shipped153312103shipp_ed
shippen14298863shipp_en
shippens15316793shippens
shipper143514033shipp_er
shippers153012303shippers
shipping163611253shipping
shippings17275683shippings
shippons15255653shippons
shipsides1544883shipsides
shoppes143411383shopp_es
slippier1256533slippier
slippiest1346463slippiest
snippier1255793snippier
snippiest1345713snippiest
stipples1247023stipples
swipples1534843swipples
thirties1139723thirties
tippier113210543_tippier
tippiest122310013_tippiest
tipples112811253_tipples
trippier1246623trippier
trippiest1336583trippiest
whimsies1635193whimsies
whinnies14237273whinnies
whipped18379333whipp_ed
whipper173611383whipp_er
whippers18329033whippers
whippet17328843whipp_et
whippets18255253whippets
whipping19328173whipping
whippings20284183whippings
whirlies14167373whirlies
whirries14136693whirries
whiskies1835953whiskies
whities133113253whi_ties
whoopies16267363whoopies
yippie13277843_yippie_
yuppies14339263_yuppies
zippier20308193_zippier
zippiest21248093_zippiest

Search took 10 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.330541487.9
2DLD Change Limit1461622208.67016858.4
3Display Results2202200.0802750.0
 (SQL Overall)1786912209.08019679.6
 
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.