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

133 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
colorings124768(None) 
coloring11414841coloring_
chlorines142512352chlorines
chlorins132612882chlorin_s
clonings11307432c_lonings
closings11277672c_losings
colorants1149862colorants
colorisms132810792colorisms
colorists112313592colorists
colorizes203014522colorizes
colouring1258732colouring_
cookings15358602co_okings
coverings15217892coverings
floorings13245092floorings
moorings11257712mo_orings
motorings1245972motorings
bloodings13245273bloodings
bookings15358733bo_okings
borings103614243__borings
bullrings12314623bullrings
calkings15289223cal_kings
callings113613833cal_lings
calorics122810463calori_cs
calories102919563calori_es
calorizes202312303calorizes
centrings12227603centrings
chlorides15289753chlorides
chlorids14299673chlori_ds
chlorin123113003chlorin__
chlorine133013303chlorin_e
chlorites142311963chlorites
chorines132917253c_horines
choring133617663c_horing_
chromings17286093chromings
clearings12286063clearings
clings95716213c_l__ings
cloning103215473c_loning_
closing103114843c_losing_
clothings15264433clothings
clouring112811273clouring_
cloying133511753c_loying_
coamings13349293co_amings
coastings12357863coastings
coatings113811843co_atings
cocoonings1552713cocoonings
codlings123110103co_dlings
cohering142413833cohering_
cohousings1642123cohousings
cojoins1638993cojo_in_s
colicines13311203colicines
colicins12312853colicin_s
colins85229043col__in_s
collaring12310563collaring_
collins93419833col_lin_s
collying14319553collying_
colognes11310603colo_gnes
cologs96517353colo___gs
colones96124433colo__nes
colonials1147913colonials
colonics123711613coloni_cs
colonies103620013coloni_es
colonises112814013colonises
colonists112512503colonists
colonitis1148763colonitis
colonizes202613183colonizes
colons86028683colo__n_s
colonus94413443colo__nus
colorant10414723coloran_t
coloreds1138093color_eds
colorers10312183color_ers
colorific1644863colorific
colorism122112433colori_sm
colorist102818993colori_st
colorize192314203colori_ze
colorized212211773colorized
colorizer202410623colorizer
colorizers21267603colorizers
colorizing2249633colorizing_
colorless1145683colorless
colorpoints1552783colorpoints
colors86622373color___s
colorways1743723colorways
combings15348323co_mbings
comings124013533c__omings
cooing94024923co_o_ing_
cooking143818973co_oking_
cooling103422573co_oling_
cooping123918933co_oping_
copings124111843c__opings
cordings123011363co_rdings
coring94433963c__oring_
couchings17285763couchings
couplings1435543couplings
couponings1542783couponings
coursings12235873coursings
covering142215723covering_
covings134511243c__ovings
cowering142514033cowering_
cowlings14359783co_wlings
decoloring1486313decoloring_
flooring12259883flooring_
florins10311643_florin_s
followings1752823followings
footings12248833fo_otings
gloomings13283973gloomings
golfings13304873gol_fings
holdings13297743hol_dings
honoring12310473honoring_
lordings10368503__lordings
losings82810623__losings
lowings113710073__lowings
moldings12267203mol_dings
mooring102514443mo_oring_
motoring11410953motoring_
noonings9246653no_onings
oolongs845953oolo__ngs
outrings92811053_outrings
pilotings1234353pilotings
recoloring1367583recoloring_
roarings9248293ro_arings
rollings9419953rol_lings
roofings12256023ro_ofings
scoldings13224133scol_dings
scourings12235293sco_urings
shorings12269483_shorings
skiorings14243793skiorings
soarings93210393so_arings
soloing82813803solo_ing_
sorings83817253__sorings
tailorings1143433tailorings
toolings9248473to_olings
tourings9277373to_urings
vaporings1544093vaporings

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411336.82621775.7
3Display Results1331330.0632111.1
 (SQL Overall)1786911337.31224438.0
 
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.