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

45 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
ventilate124838(None) 
ventilated1446361ventilated
ventilates1347601ventilates
ventilator13115112ventilator
aestivate12127663aestivate
cantillate1247343cantillate
centiare1067203centi_are
centile94217183centil__e
centiliter1245653centiliter
denitrate10810533denitrate
dentate8315153dent__ate
denticulate1445513denticulate
depilate11311703de_pilate
endplate1147083_endplate
enfilade1243743_enfilade
ensilage944713_ensilage
epilate9314283_e_pilate
estimate10912003_estimate
estivate111010003_estivate
etiolate849523_e_tiolate
eventuate12104773event_uate
festinate1249473festinate
gentile83515293gentil__e
gentility1347063gentility
intimate101013833_intimate
mutilate10312273_mutilate
pectinate1349553pectinate
petiolate1149153pe_tiolate
tantalate9107373tantalate
unventilated1653513unventilated
velate93720143ve___late
vellicate1446433vellicate
venenate1147933ven_enate
venerate11312903ven_erate
ventage11109623vent__age
ventifact1752833ventifact
ventifacts1851643ventifacts
ventilating1546343ventilating
ventilation1448163ventilation
ventilators14105063ventilators
ventilatory17114123ventilatory
vesicate131210053ve_sicate
vexillate1944553vexillate
vindicate1546353vindicate
vitiate103412953v_iti_ate

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 Filter1786911486410.423422437.4
2DLD Change Limit148641456.39023261.5
3Display Results45450.0331363.6
 (SQL Overall)178691456.84626101.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.