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 “versatilities” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 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
versatilities165607(None) 
erasabilities1549603_erasabilities
erectilities1447103_erectilities
fertilities1448813fer__tilities
overstabilities2055243overstabilities
reusabilities1549263reusabilities
variabilities1848633variabilities
versatility1755133versatilit__y
volatilities1546513v_olatilities
arabilities13413094_ar_abilities
bearabilities1748674bearabilities
bestialities1455484be_s_tialities
creativities1755764_creativities
curabilities1649384cur_abilities
deniabilities1649764deniabilities
disabilities15411104_disabilities
disutilities1355144_disutilities
durabilities1549334dur_abilities
elasticities1455094_elasticities
equabilities2348154_equabilities
feasibilities1866564feasibilities
festivities1746574fe_s_tivities
formabilities2046994formabilities
fragilities1547154_fr_agilities
friabilities1789154_friabilities
gentilities1249134ge__ntilities
gracilities1447674_gr_acilities
heritabilities1958194heritabilities
hostilities14127644_hos_tilities
meltabilities1749864meltabilities
negativities1654874ne_gativities
operabilities17510054oper_abilities
overactivities2274464overactivities
overmaturities1962384overmaturities
perishabilities2255274perishabilities
permeabilities2056824permeabilities
personalities1556474personalities
portabilities17410184portabilities
readabilities1649304readabilities
relativities1555764re_lativities
reliabilities15410444reliabilities
rentabilities15411234rentabilities
retractilities1674074retractilities
reversibilities2084154reversibilities
sectilities1348684se__ctilities
sensibilities1557364sensibilities
sensitivities1654534sensitivities
servilities1447054ser__vilities
sessilities1146404se_s_silities
severabilities1947434sever_abilities
sewabilities1748934se_wabilities
sorbabilities1746994sorbabilities
tenabilities14911484te_nabilities
tensilities1147654tens__ilities
testabilities1549934testabilities
usabilities1368984__usabilities
vagilities1447954v___agilities
venalities131510724ve_na__lities
vendibilities1955874vendibilities
venerabilities1967354venerabilities
venialities14168934venia__lities
veracities1549504ver_a__cities
verifiabilities2354434verifiabilities
versatile1245164versatil___e_
versatileness1653994versatileness
verticalities1885214verticalities
viabilities1679674v__iabilities
violabilities1856814violabilities
virilities1379124vir___ilities
visibilities1747374v_isibilities
vorticities1647084vor__ticities
wearabilities1848414wearabilities
wettabilities1847774wettabilities
workabilities2245674workabilities

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 Filter178691950240.1261418182.5
2DLD Change Limit95024745.97015916.9
3Display Results74740.0431720.9
 (SQL Overall)178691746.13929107.5
 
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.