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

93 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
valvule134366(None) 
valvula1343251valvula
valvulae1442721valvulae
valvules1443471valvules
value85719092val_u_e
valval12398862valval_
valvate133710812valvate
valve114515932valv__e
valvelet1445342valvelet
valvular1443462valvular
volvuli1352082volvuli
alible8311973_alible
allele64514563_allele
allude73910903_allude
allure63012943_allure
almuce10348213_almuce
almude9399933_almude
alula5317093_al_ula
alulae6312743_al_ulae
alvine94614583_alvine
ampule10710613_ampule
avulse935843_a_vulse
ballute938543ballute
barbule1137943barbule
bascule1136573bascule
calculi1146553calculi
calicle113111433calicle
calque17289843calqu_e
calve105919923calv__e
calycle14245833calycle
capsule1137343capsule
cellule936523cellule
halve114818923halv__e
macule104115273ma_cule
nervule1044943nervule
ovule839493__ovule
papule102212133pa_pule
pilule8411123pil_ule
saccule1136743saccule
salable91415463salable
salute64418023sal_ute
salvable1338403salvable
salvage1138193salvage
salve85022133salv__e
vacuole1245373vacuole
vagile10310543va_gile
vague96513113va_gu_e
valance1269253valance
vale74937343va___le
valence1268763valence
valgus1047103valgu_s
valguses1234233valguses
validly1435573validly
valine94623093val_ine
valise92917643val_ise
vallate103016563vallate
valley124311603val__ley
valour93010373valou_r
valours10248733valours
valse85117523val__se
valuable1336863valuable
valuate102512733valuate
valued104011153val_ued
valuer93911443val_uer
values94314943val_ues
valuta938743val_uta
valvar12388653valv_ar
valved136711043valv_ed
valveless1543163valveless
valvelets1542793valvelets
valvelike1943683valvelike
valves124113783valv_es
valving14368553valving
variole10711593variole
varve115716853varv__e
vascula1245853vascula
vatful12107083vatful_
vatfuls1384853vatfuls
vault85823763va__ult
veinule1056243veinule
veloute1037733veloute
velure939773vel_ure
venule94411763v_enule
virgule1144283virgule
voluble1244503voluble
volume11358273vol_ume
volute93912763vol_ute
volvate13317993volvate
volvulus1441933volvulus
vulture1036763vulture
vulvae12438033vulv_ae
vulval12417663vulval_
vulvate13388323vulvate

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027938.40615944.2
3Display Results93930.0303100.0
 (SQL Overall)178691938.59220797.4
 
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.