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

102 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
cornuto93703(None) 
cornute939641cornute
cornutos1046051cornutos
cobnut10311322cobnut_
cobnuts1135352cobnuts
conto76027172co_n_to
coranto9311892coranto
cornet84436732cornet_
cornets94820572cornets
cornu75921322cornu__
cornua85411902cornu_a
cornual94210172cornual
cornus84816562cornu_s
cornuted1137472cornuted
hornito1047072hornito
bonito8313433bo_nito
bornite9311183bornite
canto74931013c_an_to
carnet84732873carnet_
carnets93918403carnets
cento76625173c_en_to
coconut11511473coconut_
coconuts1246333coconuts
coenure968153coenure
coenuri945453coenuri
cogito939203co_gito
cognate10312203cognate
colugo935863co_lugo
commute134310443commute
compute134513663compute
concho134414263co_ncho
condo85322593co_n_do
confute1239263confute
congo85623133co_n_go
conjunto1744653conjunto
connate9315753connate
connote9311613connote
conte76633203co_n_te
contos84923233co_n_tos
conus76726533co_nu_s
copout10418783copout_
copouts11311083copouts
coquito1845403coquito
corantos10310103corantos
cordate10315223cordate
cordite10315263cordite
corduroy1442873corduroy
corium10315723coriu_m
corn69945813corn___
corncob1345663corncob
cornea84018933corn_ea
corneal94414503corneal
corneas94717003corneas
corned95224523corn_ed
cornel84020053corn_el
cornels94716663cornels
corner84625623corn_er
corners94723313corners
cornetcy1544303cornetcy
cornfed1337383cornfed
cornhusk1742043cornhusk
cornice11612933cornice
cornier93017093cornier
cornify1536253cornify
cornily12410853cornily
corning103720123corning
cornrow1245603cornrow
corns76034763corn__s
cornuses10310033cornuses
corny106023273corn__y
coronate103018213coronate
coronet94227173coronet_
coronets103814363coronets
corpus106015293corpu_s
corrupt1149103corrupt
corruptor1344043corruptor
corrupts1244983corrupts
corset85636223corset_
corsets94819803corsets
corvet114626933corvet_
corvets124715023corvets
count74932053coun_t_
counts84618273coun_ts
county114313323coun_ty
couranto1046903couranto
couth106122493co__uth
croute84617273c_route
crouton947133c_routon
crypto13367273c_rypto
donut6324513do_nut_
donuts7410583do_nuts
hognut1039413hognut_
hognuts1134183hognuts
hornet94926433hornet_
hornets104113553hornets
hornitos1145393hornitos
onto46127663_o_n_to
ornate6315143_ornate
porno75120653porn__o
pronto8313993pron_to
tenuto648743_tenuto
tornado845673tornado

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271027.25018486.5
3Display Results1021020.0303400.0
 (SQL Overall)1786911027.67023297.4
 
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.