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

108 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
soprani93740(None) 
soprano937001soprano
sopranino1143912sopranino
sopranos1046432sopranos
sovran937152sovran_
sovrans1036482sovrans
sprain83614862s_prain
sprang95713522s_prang
borane84620213bo_rane
copra98115463copra__
coprah133710603copra_h
coprahs14338153coprahs
copras103517153copra_s
courant9317973courant
dopant9316133dop_ant
esophagi1454013esophagi
gourami1083803gourami
guarani8106273guarani
isoprene1045613isoprene
korai97018523ko_ra_i
loran55925093lo_ran_
lorans65117603lo_rans
moirai886913moira_i
oorali6311263_oorali
operand1038003_operand
operant9317223_operant
orang65119943_o_rang
ourang73311063_ourang
ourari63413543_ourari
prang84820323__prang
prank115019453__prank
rani46640113___rani
safranin1145213safranin
saran53730303s_aran_
sarans64224433s_arans
serai56830163s_era_i
serranid947573serranid
serrano768463serrano
shopman14247263shopman_
shoran94016043shoran_
shorans102812413shorans
shrank13359123s_hrank
soaring83521893soaring
socman1039813socman_
solan55328153so_lan_
soland75115043so_land
solanin7311943so_lanin
solano65314183so_lano
solans64122493so_lans
soldan73511853soldan_
soldans83210403soldans
soman75024903so_man_
somans84619303so_mans
somoni8310743so_moni
sonant6621953so_nant
sonorant8411703sonorant
sopping123917203sopping
sopraninos1251983sopraninos
sora45746913so_ra__
soras55041013so_ra_s
sordini8228963sordini
sori46039843so_r__i
soring74731883so_ring
sorn46641063so_r_n_
sorns55028423so_r_ns
souari6311383so_uari
soudan73210353soudan_
soudans8309353soudans
souring83219063souring
soutane7312063soutane
sovranly1443453sovranly
sovranty1443463sovranty
sowans94215893so_wans
spahi10311143s_p_ahi
span65234663s_p_an_
spang84919733s_p_ang
spank115919573s_p_ank
spans74528733s_p_ans
spean74620513s_pean_
speans85417143s_peans
spirant9814293spirant
sporadic1345053sporadic
sporal82915453spora_l
sporangia1243503sporangia
sporing104319413sporing
sporran936743sporran_
sporrans1045523sporrans
sprag86418693s_pra_g
sprags95715823s_prags
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
strain64919573s_train
strand74514823s_trand
strang75718313s_trang
strati63518903s_trati
supra73614253supra__
woorali1045263woorali
woorari1044633woorari

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.406440125.6
2DLD Change Limit1340271087.28318402.7
3Display Results1081080.0303600.0
 (SQL Overall)1786911087.71923149.5
 
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.