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

49 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
coriander124566(None) 
corianders1344901corianders
colander1139032co_lander
commander16127402commander
brander103915823_br_ander
cinder94119123c__i_nder
cofounder1543823cofounder
coiner84323783co_i_n_er
coinfer12419393co_i_nfer
cointer93616723co_i_nter
colanders1238013co_landers
coleader1139183colea_der
commanded17136503commanded
commandeer17124113commandeer
commanders17146683commanders
commandery20134253commandery
commender16167923commender
contender1239563contender
corder94322883cor___der
corner84625623cor__n_er
cornier93017093cor__nier
coromandel1552833coromandel
coroner94218203cor_on_er
corrade101111043corra_de_
corraded12128293corra_ded
corrades111211263corra_des
cosigner1135953cosign_er
cowinner1334753cowi_nner
cranker133612793c_r_anker
cringer103514243c_ri_nger
curandera1242853cur_andera
curandero1242513cur_andero
cylinder1433383cyli_nder
forrader1236153forra_der
forrarder1343623forrarder
forwarder1644133forwarder
germander1345363germander
goosander1143253goosander
grander93315873_gr_ander
grinder93312393_gri_nder
joinder15337593jo_i_nder
loriner7511893lori_n_er
lowlander1342993lowlander
normande1145943normande_
oleander936403_oleander
orienter838313_orienter
pomander1347083po_mander
solander948123so_lander
strander97112063str_ander

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.406440125.6
2DLD Change Limit148641496.56022658.7
3Display Results49490.0163062.5
 (SQL Overall)178691496.98225593.1
 
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.