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 “conto” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
conto7602717(None) 
canto74931011canto
cento76625171cento
condo85322591condo
congo85623131congo
conte76633201conte
contos84923231contos
onto46127661_onto
bento75922952bento
bongo85720942bongo
bonito8313432bonito
canso75019402canso
cant66362022cant_
canton85722992canton
cantor85621522cantor
cantos84826972cantos
cants77036942cants
canty105226802canty
cent67451012cent_
centos85920462centos
cents74730332cents
centu76119412centu
coat67558342coat_
coati75624632coati
coats75634992coats
coco87330602co_co
coft97939682coft_
cogito939202cogito
coho97524492co_ho
colt67158242colt_
colts76633292colts
combo114519432combo
compo115318572compo
comte96125472comte
con510268022con__
conch124620072conch
concho134414262concho
condom114215362condom
condor94616962condor
condos94322332condos
cone67256962con_e
coned86040052coned
cones76457422cones
coney105932882coney
conga85419872conga
conge85227592conge
congos94219882congos
congou94313242congou
coni65534802con_i
conic95329792conic
conin76232722conin
conk106531442con_k
conks115525702conks
conky145818742conky
conn66229132con_n
conns75024232conns
cons66057692con_s
consol82614112consol
contes84432912contes
contort91422342contort
contour939962contour
contra83314692contra
control9310672control
conus76726532conus
convoy14348542convoy
cony96537832con_y
coo59566362co__o
coot67860382coot_
coots75636842coots
coranto9311892coranto
cornuto937022cornuto
cost68057942cost_
costa75523732costa
costs77231142costs
cot510483222co_t_
cote66648732co_te
cots68054842co_ts
cotta75818572cotta
cotton8312992cotton
count74932052count_
counts84618272counts
county114313322county
couth106122482couth
cunt66243672cunt_
cunts76125122cunts
font77143752font_
fonts86124752fonts
gonzo15310242gonzo
into45026152_into
junto125114562junto
koto86323462ko_to
lento57223392lento
lotto55217572lotto
molto75619602molto
mondo85721232mondo
mongo810122412mongo
mono66036712mon_o
monte75829772monte
month104818422month
motto76119512motto
ono36838032_on_o
otto45220642_otto
panto76129412panto
pinto75625752pinto
ponton83217642ponton
potto75320942potto
pronto8313992pronto
punto75121322punto
rondo65218372rondo
roto45935052ro_to
santo56227282santo
tanto55724942tanto
tondo69718682tondo
unto45824282_unto
wont75842502wont_
wonton93410962wonton
wonts87621542wonts

Search took 2 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 Filter178691538000.1231452772.4
2DLD Change Limit538001171.72031279.1
3Display Results1171170.0303900.0
 (SQL Overall)1786911171.87395403.6
 
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.