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

75 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
sopranos104643(None) 
soprano937001soprano_
serranos857872serranos
solanos74412852so_lanos
soprani937402sopran_i
sopraninos1251982sopraninos
sovrans1036482sovran_s
sprangs104610052s_prangs
boranes93720403bo_ranes
coprahs14338153copra_hs
copras103517153copra__s
corantos10310103co_rantos
courantos1145793courantos
courants10310803courants
dopants1038433dop_ants
dorados938203do_rados
isoprenes1146113isoprenes
journos14134943jour_nos
lorans65117603lo_ran_s
marranos1038423marranos
operands1146813_operands
operants1039483_operants
orangs74116033_o_rangs
ourangs8318503_ourangs
pianos84315933__pianos
poblanos1244993poblanos
pompanos1445243pompanos
pornos85015253po_r_nos
prangs94816233__prangs
pranks124814723__pranks
praos74923563__pra_os
romanos94311483ro_manos
sapsagos1143773sapsagos
sarans64224433s_aran_s
serrano768463serrano_
shorans102812413shoran_s
soarings93210393soarings
solands84412343so_lands
solano65314183so_lano_
solans64122493so_lan_s
soldans83210403soldan_s
somans84619303so_man_s
sonants7511233so_nants
sonorants947083sonorants
sopranino1143913sopranino
soras55041013so_ra__s
sorghos11327603so_rghos
sorgos74514663so_r_gos
sorings83817253so_rings
sorns55028423so_r_n_s
soudans8309353soudan_s
soutanes8312933soutanes
sovran937153sovran__
sovranly1443453sovranly
sovranty1443463sovranty
sowans94215893so_wan_s
spanks124514123s_p_anks
spans74528733s_p_an_s
speans85417143s_pean_s
spirants1088283spirants
sporrans1045523sporran_s
sprags95715823s_pra_gs
sprains93013593s_prains
sprang95713523s_pran_g
sprats85819933s_pra_ts
sprawls12176373s_prawls
sprays115913643s_pra_ys
springs104415923s_prings
sprints94113773s_prints
stopbanks1743033stopbanks
strands83711953s_trands
supremos1245813supremos
touracos1045313touracos
volcanos1344733volcanos
zebranos1943713zebranos

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit146162757.65619091.2
3Display Results75750.0332272.7
 (SQL Overall)178691758.10922036.1
 
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.