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

70 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
urbanises1110664(None) 
urbanise10107281urbanise_
urbanised1295121urbanised
urbanisms13115991urbanisms
urbanists11105481urbanists
urbanites11105911urbanites
urbanizes20106251urbanizes
organises1048682organises
uranides92211282ur_anides
uranisms1099972ur_anisms
uranites82514642ur_anites
urbanism12107212urbanis_m
urbanist10109072urbanis_t
urbanite1097182urbanite_
urbanities1245332urbanities
urbanize19106732urbanize_
urbanized21105902urbanized
abatises10311013_abatises
anises64826693___anises
arbalists1148483arbalists
banishes131812463__banishes
botanises1139163botanises
braises93818873br_a_ises
bubalises1346323bubalises
ebonises1039223_ebonises
exurbanites2052143exurbanites
fraises104215693fr_a_ises
furanoses1244993fur_anoses
granites92116363gr_anites
humanises1448313humanises
kyanises15206393_kyanises
organise939323organise_
organised1146353organised
organiser1045483organiser
organisers1143623organisers
organisms1247213organisms
organists1047383organists
organizes1948753organizes
paganises1239723paganises
praises94121103pr_a_ises
praxises1739063pr_axises
raises64826543_r_a_ises
realises82420183_realises
romanises11311573romanises
rubasses1035493ruba_sses
ruralises939123ruralises
suburbanises16102193suburbanises
surbases10310003surba__ses
tetanises979873tetanises
treatises9310373treatises
turbaries1147743turbari_es
unionises947163unionises
upraises10188473upra_ises
uraeuses835383ur_aeuses
uralites82112723ur_alites
uranias72113813ur_ani_as
uranide82212093ur_anide_
uranism91112513ur_anis_m
uranite72515693ur_anite_
uraniums10117163ur_aniums
urases63723563ur_a__ses
urbane82211383urban__e_
urbaner9177133urban__er
urbanest10117533urbanes_t
urbanising1344653urbanising
urbanistic1443923urbanistic
urbanity13105303urbani_ty
ureases74416723urea__ses
vulcanises1544223vulcanises
womanises1448063womanises

Search took 8 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 Limit148641706.78021923.5
3Display Results70700.0302333.3
 (SQL Overall)178691707.23324705.0
 
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.