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

58 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
venereal114508(None) 
funereal1143942funereal
general81010932gener_al
ventral103612172ventr_al
aethereal1244593aethereal
bonemeal1245163bonemeal
central93114473centr_al
cereal8315833__cereal
deferral1244353deferral
demersal1145263demersal
deverbal1444483deverbal
enteral73516433_enter_al
entreat7315263_entreat
eternal72910893_eternal
ethereal1146783ethereal
federal1148533feder_al
funeral1037623funer_al
genera71211713gener_a_
generals9109333gener_als
generical1246983generical
mineral9312733miner_al
noncereal1157733noncereal
referral1144403referral
renewal1038703rene_wal
reversal1145843reversal
several1039533sever_al
sidereal946053sidereal
tenurial847703tenurial
unreal64414453_un_real
veered103612743ve_ere_d
vegetal1156303vege_tal
venal85523213ven___al
veneer94511693vene_e_r
veneered1235983veneered
veneerer1145033veneerer
veneerers1244523veneerers
veneers103710293vene_ers
venene92912523venene__
venenes102712133venene_s
venerable1438483venerable
venerably1746423venerably
venerate11312893venerate
veneries112815023veneries
venery123710663vener__y
venetian1146073venetian
venial94218283ven__ial
venire93513693venire__
venireman1452153venireman
venires103012453venire_s
ventrals11299993ventr_als
verbal112513663v__erbal
vernal93514213v__ernal
versal93013753v__ersal
vesperal1344883vesper_al
vestral104111013vestr_al
veteran1039343veter_an
viceregal1551613viceregal
vineal94814743vin__eal

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.1731032896.0
2DLD Change Limit146162588.04618165.8
3Display Results58580.0461260.9
 (SQL Overall)178691588.26521620.2
 
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.