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

94 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
serovar104614(None) 
serovars1145231serovars
samovar1244242samovar
serosa6313022serosa_
serosae7310242serosae
serosal7311152serosal
serosas7312662serosas
serval93913412ser_val
server94917712ser_ver
aerobat9514473aerobat
aerosat7417183aerosat
areolar779223areolar
bezoar1736913bezo_ar
deodar837713de_odar
deriver114213913deriver
drover104614593_drover
escolar946053escolar
fervor1235643fer_vor
fervour1343103fervour
lekvar1333043le_kvar
peroral9314793peroral
prover113819723_prover
prowar114110943_prowar
recover124312623recover
removal1236733removal
remover124612273remover
reproval1355773reproval
reprover13229203reprover
roar46328573__ro_ar
rover85527373__rover
samovars1343703samovars
sardar73013173sar_dar
sarsar63011843sar_sar
scholar1236953scholar
scrota8310203scrota_
scrotal938493scrotal
sear47353843se___ar
seconal9310073seconal
secpar1037923se_cpar
secular92211533secular
seggar8357813se_ggar
selva83014273se_lva_
selvas93812913se_lvas
seminar979753seminar
semioval1346223semioval
senor53822803seno__r
senora63216163senora_
senoras72714953senoras
sera46141393ser__a_
serac75925203ser__ac
serai56830163ser__ai
seral56336383ser__al
serdab937833ser_dab
serener73415763serener
serer55935513ser__er
serger73819743ser_ger
serial64625863ser_ial
serous65023563sero_us
serow86720443sero__w
serows96016393sero_ws
serumal938783serumal
servals103410743ser_vals
servant10313623ser_vant
serve85425963ser_v_e
served104616813ser_ved
servers103214833ser_vers
serves94423653ser_ves
servo84516683ser_v_o
servos93812723ser_vos
sever85426053se__ver
sewar85421103se__war
shofar1236313s_hofar
shover124515993s_hover
shriver134712193shriver
shrove125412233shrov_e
sirdar7269103sir_dar
soar46838673s__o_ar
sofar86115493s__ofar
solar55927343s__olar
sonar56523423s__onar
sororal7310653sororal
sowar85821343s__owar
stover94115643s_tover
striver104315203striver
stroker114113523stroker
stroma84313073stroma_
stromal93010593stromal
strove95014793strov_e
stroyer103510783stroyer
suboval12216723suboval
swerver1365733swer_ver
trocar848773_trocar
trover95014663_trover
uproar8106933upro_ar

Search took 7 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.393454684.5
2DLD Change Limit134027946.07622058.4
3Display Results94940.0303133.3
 (SQL Overall)178691946.49927495.2
 
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.