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

90 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
cornrow124560(None) 
cornrows1345311cornrows
borrow114310722bor_row
corncob1345662corncob
cornrowed1543622cornrowed
morrow113510092mor_row
sorrow9339442sor_row
arrow83414883_ar_row
barrow114512763bar_row
borneol936823borneol
borrows12349253bor_rows
burrow114610803bur_row
carrom10513403car_rom
carrot8423123car_rot
cockcrow1842753cockcrow
condo85322593co_ndo_
condom114215363co_ndom
condor94616963co_ndor
condos94322333co_ndos
congo85623133co_ngo_
congos94219883co_ngos
congou94313243co_ngou
consol82614113co_nsol
conto76027173co_nto_
contos84923233co_ntos
control9310673control
convoy14348543co_nvoy
coranto9311893coranto_
corantos10310103corantos
cordon95017293cor_don
corduroy1442863corduroy
corer75538873corer__
corers85231073corer_s
corn69945813corn___
corncobs1444723corncobs
corncrib1443893corncrib
cornea84018923corn_ea
corneal94414503corneal
corneas94716993corneas
corned95224523corn_ed
cornel84020053corn_el
cornels94716663cornels
corneous10310033corneous
corner84625623corn_er
cornered11311133cornered
corners94723313corners
cornet84436733corn_et
cornets94820573cornets
cornfed1337383cornfed
cornice11612933cornice
cornier93017083cornier
cornify1536253cornify
cornily12410853cornily
corning103720123corning
cornpone1246933cornpone
cornrowing1643613cornrowing
corns76034763corn__s
cornu75921323corn__u
cornua85411903corn_ua
cornual94210173cornual
cornus84816563corn_us
cornute939633cornute
cornuto937023cornuto
cornutos1046033cornutos
corny106023273corn__y
corpora1139353corpora
corral83616253cor_ral
corrie83621213cor_rie
corrode101310573cor_rode
corrody13136143cor_rody
crow96428133c___row
downbow1653393downbow
farrow12309973far_row
furrow12427743fur_row
harrow122610773har_row
horror988723hor_ror
lowbrow1543273lowbrow
marrow112812603mar_row
moonbow1443873moonbow
morro73216953mor_ro_
morros83714673mor_ros
morrows12318723mor_rows
narrow9269143nar_row
outrow9311173_outrow
porno75120653porn_o_
pornos85015253porn_os
sorrows10278403sor_rows
torero6313203torero_
toreros7311343toreros
yarrow12287933yar_row

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit134027906.53020524.8
3Display Results90900.0332727.3
 (SQL Overall)178691906.71926594.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.