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 “ruralities” 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
ruralities104857(None) 
auralities10410221auralities
ruralites947941ruralit_es
brutalities1345442brutalities
dualities10310442du_alities
frugalities1544162frugalities
moralities121111922moralities
oralities91214122_oralities
pluralities1345682pluralities
qualities18311222qu_alities
realities9316312r_ealities
regalities11410592regalities
ruralises939122rurali_ses
ruralite848962ruralit_e_
ruralizes1858772rurali_zes
uralites82112722_uralit_es
amoralities1347423amoralities
analities9715873_analities
audacities1345333audacities
axialities1747733axialities
banalities1249813banalities
carnalities1348783carnalities
causalities1346223causalities
chiralities1646513chiralities
curabilities1649403curabilities
durabilities1549343durabilities
equalities1949013equalities
extralities1848233extralities
fatalities1349443fatalities
feracities1548713feracities
feudalities1545343feudalities
finalities1349903finalities
formalities16137823formalities
frailties1245853_frailties
fugacities1643833fugacities
furmities1447543fur_mities
futilities1348863futilities
gravities1338303_gravities
humanities1547063humanities
humilities1547703humilities
idealities1148783idealities
irrealities1146213irrealities
legalities1148913legalities
localities1259733localities
modalities13138813modalities
molalities121110283molalities
mortalities1348423mortalities
mutualities1395833mutualities
nasalities1048563nasalities
natalities10410663natalities
neutralities1246463neutralities
nodalities11138583nodalities
normalities13148113normalities
nubilities1249723nubilities
nullities949353nu_llities
ovalities12119803_ovalities
penalities121313473penalities
primalities1548293primalities
puerilities1347533puerilities
purities10316283pur__ities
qualifies2147503qu_alifies
rapacities1446543rapacities
rarities8316333__rarities
rascalities1347223rascalities
realties8514853r_eal_ties
royalties1244913royal_ties
rugosities1144723rugosities
ruralise839643rurali_se_
ruralised1046593rurali_sed
ruralising1146443ruralising
ruralisms1147353rurali_sms
ruralists947643rurali_sts
rurality1137403ruralit__y
ruralize1739233rurali_ze_
ruralized1947903rurali_zed
ruralizing2047883ruralizing
sodalities11138703sodalities
spiralities1348013spiralities
suavities1248413su_avities
tonalities101711733tonalities
totalities101210783totalities
unrealities1147533unrealities
uralite71714103_uralit_e_
uralitic10158463_uraliti_c
uranites82514643_uranit_es
urbanities1245333urbanities
utilities9610803_utilities
venalities131510723venalities
veracities1549503veracities
virilities1379123virilities
vitalities1349093vitalities
vocalities1549393vocalities
voracities1547063voracities

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 Filter1786911406030.406440125.6
2DLD Change Limit140603935.65624859.1
3Display Results93930.0462021.7
 (SQL Overall)178691936.10829255.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.