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

102 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
cipolins123803(None) 
cipolin1148781cipolin_
capelins12311132capelins
caplins113515992cap_lins
cipollino1342382cipollino
cipollinos1451392cipollinos
colins85229042c__olins
picolins1239852picolins
violins10311452vi_olins
aiblins9311473ai_blins
aiolis6316843ai_oli_s
biotins93114453bi_otins
cajoling18318423cajoling
capelans1238013capelans
capelin11510973capelin_
caplin103216303cap_lin_
capons104119503capo__ns
captains121810573captains
carlins93921923c_arlins
caroling113317003caroling
carotins102315583carotins
catlins93818843c_atlins
cephalins1666603cephalins
chitlins13289393chitlins
chlorins132612883chlorins
choline122915383c_holine
cholines132214493c_holines
chopins142312243c_hopins
cibols1039523cibol__s
cicelies1269753cicelies
cichlids1643663cichlids
cinerins10414103cinerins
cions75222853ci_o__ns
cioppino1443343cioppino
cioppinos1542203cioppinos
ciphonies1646543ciphonies
circling1338423circling
citolas939363citol_as
citoles9312553citol_es
citrins92614363ci_trins
civilians1443593civilians
codlins104116243c_odlins
coins75834553c__o_ins
cojoins1638993cojo_ins
colics104219903c__olics
colies84837053c__olies
colin76231693c__olin_
collins93419833c_ollins
colons86028683c__olons
complins14313113complins
conins84327233c__onins
coolies93824963c_oolies
cooling103422573c_ooling
covins114618063c__ovins
crinoline1147773crinoline
crinolines1246733crinolines
crippling1644093crippling
cupeling1338863cupeling
cupolaing1443403cupolaing
cupolas11277753cupol_as
cyclins1438303c_yclins
cymlins1436693c_ymlins
digoxins1744293digoxins
dioxins1568003di_oxins
diploids1247843diploids
dipodies1238413dipodies
dipoles101013753dipol_es
eidolons944983eidolons
gipons9389603gipo__ns
hipline12311423hip_line
hiplines13310593hip_lines
inulins7311493_inulins
iodins74216523_i_odins
isoline7314013_isoline
isolines8312303_isolines
kaolins1139363_kaolins
kipskins1343263kipskins
lanolins8310533lanolins
lipins85016883lip__ins
lipoids1038233lipo_ids
lupulins1044653lupulins
nicotins1058173nicotins
picolin11310883picolin_
picoline12310853picoline
picolines1339623picolines
pipeline12149503pipeline
pipelines13178353pipelines
pipkins15328183pip_kins
pippins10319753pip_pins
polies84034583__polies
poling93526503__poling
polios84019723__polios
polis74731163__poli_s
poplins11313153__poplins
quinolins1844793quinolins
rippling13197573rippling
saponins1039453saponins
simlins9311843si_mlins
sirloins836723sirloins
tippling13196703tippling
tripolis1038713tripoli_s
violin9311983vi_olin_

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.423422437.4
2DLD Change Limit1461621027.84318636.0
3Display Results1021020.0303400.0
 (SQL Overall)1786911028.29621539.4
 
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.