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

44 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
urbanities124533(None) 
urbanites11105911urbanit_es
uranites82514642ur_anit_es
urbanises11106642urbani_ses
urbanite1097182urbanit_e_
urbanizes20106252urbani_zes
auralities10410223aur_alities
banties94324763__ban_ties
barbarities1544993barbarities
canities101519263__canities
exurbanites2052143exurbanit_es
granites92116363gr_anit_es
gravities1338303gr_avities
humanities1547063humanities
inanities9312443_inanities
insanities1049423insanities
mundanities1444413mundanities
oralities91214123or_alities
profanities1676253profanities
rarities8316333_r_arities
realities9316313_realities
ruralities1048573ruralities
sanities81219773__sanities
trinities9313343tr_inities
triunities1046103triunities
turbidities14174553turbidities
unities72520153u___nities
unrealities1147533unrealities
uralites82112723ur_alit_es
uranides92211283ur_ani_des
uraninites1045623ur_aninites
uranite72515693ur_anit_e_
uranitic10148683ur_aniti_c
urbanise10107283urbani_se_
urbanised1295123urbani_sed
urbanising1344653urbanising
urbanisms13115993urbani_sms
urbanistic1443923urbanisti_c
urbanists11105483urbani_sts
urbanity13105303urbanit__y
urbanize19106733urbani_ze_
urbanized21105903urbani_zed
urbanizing2245393urbanizing
vanities111414493__vanities

Search took 6 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 Limit140603445.44025846.1
3Display Results44440.0133384.6
 (SQL Overall)178691445.85930498.5
 
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.