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

90 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
valvules144347(None) 
valvule1343661valvule_
valguses1234232valguses
values94314942val_u_es
valveless1543162valveless
valvelet1445342valvelet
valvelets1542792valvelets
valves124113782valv__es
valvula1343252valvul_a
valvulae1442722valvulae
valvular1443462valvular
volvulus1441932volvulus
alleles73812033_alleles
alludes83610333_alludes
allures72913113_allures
almuces11316823_almuces
almudes10418263_almudes
ampules1189433_ampules
avulse935843_a_vulse
avulses1035433_a_vulses
ballutes1037523ballutes
barbules1238043barbules
bascules1236683bascules
calculus1255333calculus
calicles123811423calicles
calluses1039323calluses
calques182710193calqu_es
calves115119283calv__es
calycles15295693calycles
capsules1236623capsules
caules85927253ca__ules
cellules1036813cellules
dalles74222063dal__les
favuses1336183fa_vuses
galluses936963galluses
halluces1335613halluces
halves124717093halv__es
macules114015133ma_cules
nervules1145013nervules
ovules938223__ovules
papules112411573pa_pules
pilules9510623pil_ules
saccules1237033saccules
salutes73716253sal_utes
salvages1238123salvages
salves94221763salv__es
salvoes102811313salv_oes
taluses7311213tal_uses
vacuoles1345013vacuoles
valances1398763valances
valences1388513valences
vales85434263va___les
valgus1047103valgu__s
valines104520213val_ines
valises103516263val_ises
valley124311603val__ley
valleys13407483val__leys
valours10248733valou_rs
valses94514613val__ses
valuables1442973valuables
valuates112811193valuates
value85719093val_u_e_
valued104011153val_u_ed
valueless1242843valueless
valuer93911443val_u_er
valuers10328943val_uers
valutas1036533val_utas
valval12398863valval__
valvate133710813valvate_
valve114515933valv__e_
valved136711043valv__ed
valvulitis1651663valvulitis
varioles11711123varioles
varuses10310623va_ruses
varves124414783varv__es
vatfuls1384853vatful_s
vaults94511673va__ults
veinules1135913veinules
veloutes1136153veloutes
velures1039093vel_ures
venules104011483v_enules
virgules1244333virgules
volumes12298233vol_umes
volutes102710983vol_utes
volvoxes2142243volvoxes
volvuli1352083volvul_i
volvuluses1651693volvuluses
vulguses1243503vulguses
vultures1137213vultures
walruses11554973walruses

Search took 10 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.1731032896.0
2DLD Change Limit146162909.50015385.5
3Display Results90900.0461956.5
 (SQL Overall)178691909.71918385.7
 
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.