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

99 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
colinear104591(None) 
collinear1144111collinear
bilinear1044042bilinear
cocinera1245552cocinera
coiner84323782co_ine_r
linear65113342__linear
nonlinear944822nonlinear
aliner65621983_aline_r
bolivar1244853boli_var
byliner1235723byline_r
calendar1145013calendar
caliber1139733calibe_r
caliper11410963calipe_r
choline122915383choline__
cholines132214493choline_s
clear76219053c_l__ear
clinal8311553c_lin_al
cline76428533c_line__
clines84926043c_line_s
clinger103812153c_linger
clinker133811663c_linker
cloner84418093c_lone_r
coalier93416183coali_e_r
coappear1442893coappear
cochineal1643513cochineal
cochlear1543593cochlear
cocineras1344963cocineras
coiler84421593co_ile_r
coined94523603co_ine_d
coiners93620753co_iners
coinfer12419393co_infer
cointer93616723co_inter
colander1139033colander
colder95121853col_de_r
coldness1137953coldness
colead94114643col__ead
colies84837053coli_e_s
colin76231693colin___
colinearity1653543colinearity
colins85229043colin__s
coliseum1244253coliseum
collar83816173col__lar
collider113410423collide_r
collier93618153collie_r
colone85425003colone__
colonel94213283colone_l
colonels104210453colonels
colones96124433colone_s
colonial10411343colonial
colorer9312523colore_r
colter84625093col_te_r
columnar1243713columnar
columnea1243673columnea_
columneas1343013columneas
combiner14259723combine_r
confiner13311193confine_r
conifer123212643conife_r
conine84528553conine__
conines93827793conine_s
conner84423963co_nne_r
copier103722893copi_e_r
coplanar1244473coplan_ar
cornea84018923co_rnea_
corneal94414503co_rneal
corneas94717003co_rneas
corner84625623co_rne_r
cornier93017093cornie_r
coroner94218203corone_r
cosier84423753cosi_e_r
cosigner1135953cosigne_r
cosine83823513cosine__
cosines94122673cosine_s
cosiness103214283cosiness
cotinga10348023cotinga_
cotingas11316323cotingas
cowier113616163cowi_e_r
cowinner1334753cowinner
cozener18328953cozene_r
cozier173315143cozi_e_r
coziness19319823coziness
culinary1355853culin_ary
cylinder1433383cylinder
domineer1146273domineer
eloiner7149183eloine_r
foliar93210973foli__ar
holier94921623holi_e_r
holiness112512503holiness
joiner134114133jo_ine_r
lineal65616023__lineal
liner55938923__line_r
loriner7511893lorine_r
moline84422033moline__
nonlineal946163nonlineal
policer113112683police_r
politer92417073polite_r
solider82912453solide_r
solunar735283solun_ar
trilinear943173trilinear
unilinear942913unilinear

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 Filter1786911461620.406440125.6
2DLD Change Limit146162997.20320291.8
3Display Results99990.0303300.0
 (SQL Overall)178691997.63923391.9
 
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.