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

43 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
collinear114411(None) 
colinear1045911co_linear
collider113410422collide_r
collier93618152colli_e_r
nonlinear944822nonlinear
bilinear1044043_bilinear
calliper1247513callipe_r
coalier93416183coali_e_r
cochineal1643513cochineal
cocinera1245553co_cinera
coiner84323783co__ine_r
collar83816173coll___ar
colleger11227933college_r
collide103214793collide__
collided12309803collide_d
colliders12298073colliders
collides113214473collide_s
collie83621993colli_e__
collied103316673colli_e_d
colliers103613583colli_ers
colliery13307363colli_ery
collies94326583colli_e_s
collinearity1762193collinearity
collins93419833collin__s
collinses1138283collinses
collinsia11123783collinsia
collinsias12143893collinsias
colluder11276873collude_r
columnar1243713column_ar
columnea1243673columnea_
columneas1343013columneas
combiner14259723combine_r
confiner13311193confine_r
coplanar1244473coplan_ar
jollier142911003jolli_e_r
jolliness1636213jolliness
linear65113343___linear
milliner102811863milline_r
noncollinear1461913noncollinear
nonlineal946163nonlineal
pollinia1046803pollinia_
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 Filter1786911486410.440406115.9
2DLD Change Limit148641436.70322175.3
3Display Results43430.0133307.7
 (SQL Overall)178691437.15624970.8
 
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.