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

107 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
soprano93700(None) 
soprani937401soprani
sopranos1046431sopranos
serrano768462serrano
solano65314182so_lano
sopranino1143912sopranino
sovran937152sovran_
sovrans1036482sovrans
sprang95713522s_prang
borane84620213bo_rane
copra98115463copra__
coprah133710603copra_h
coprahs14338153coprahs
copras103517153copra_s
coranto9311893co_ranto
courant9317973courant
couranto1046903couranto
dopant9316133dop_ant
dorado838813do_rado
isoprene1045613isoprene
journo13135293jour_no
loran55925093lo_ran_
lorans65117603lo_rans
marrano939423marrano
operand1038003_operand
operant9317223_operant
orang65119943_o_rang
ourang73311063_ourang
piano76118713__piano
poblano1145093poblano
pompano1345203pompano
porno75120653po_r_no
prang84820323__prang
prank115019453__prank
prao66229023__pra_o
romano84912943ro_mano
sapsago1044303sapsago
saran53730303s_aran_
sarans64224433s_arans
serranos857873serranos
shopman14247263shopman_
shoran94016043shoran_
shorans102812413shorans
shrank13359123s_hrank
soaring83521893soaring
socman1039813socman_
solan55328153so_lan_
soland75115043so_land
solanos74412853so_lanos
solans64122493so_lans
soldan73511853soldan_
soldans83210403soldans
soman75024903so_man_
somans84619303so_mans
sonant6621953so_nant
sonorant8411703sonorant
sopping123917203sopping
sopraninos1251983sopraninos
sora45746913so_ra__
soras55041013so_ra_s
sordino8219443sordino
sorgho10348713so_rgho
sorgo64719723so_r_go
soring74731883so_ring
sorn46641063so_r_n_
sorns55028423so_r_ns
soudan73210353soudan_
soudans8309353soudans
souring83219063souring
soutane7312063soutane
sovranly1443453sovranly
sovranty1443463sovranty
sowans94215893so_wans
spado83713703s_p_ado
span65234663s_p_an_
spang84919733s_p_ang
spank115919573s_p_ank
spans74528733s_p_ans
spean74620513s_pean_
speans85417143s_peans
spirant9814293spirant
sporal82915453spora_l
sporing104319413sporing
sporran936743sporran_
sporrans1045523sporrans
sprag86418693s_pra_g
sprags95715823s_prags
sprain83614863s_prain
sprains93013593s_prains
sprangs104610053s_prangs
sprat76635973s_pra_t
sprats85819933s_prats
sprawl11188063s_prawl
spray106720063s_pra_y
sprays115913643s_prays
sprent84522383s_prent
spring94526013s_pring
sprint84526793s_print
sprung94610033s_prung
stopbank1643453stopbank
strand74514823s_trand
strang75718313s_trang
supra73614253supra__
supremo1145723supremo
touraco945363touraco
volcano1244613volcano
zebrano1843853zebrano

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.403443402.0
2DLD Change Limit1340271077.22018563.3
3Display Results1071070.0333242.4
 (SQL Overall)1786911077.65623340.0
 
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.