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

58 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
botanised124639(None) 
botanise1039641botanise_
botanises1139161botanises
botanized2147281botanized
botanies10312852botani_es
botanist10412032botanis_t
botanists1148202botanists
botanize1948752botanize_
botanizer2046242botanizer
botanizes2048422botanizes
romanised1247922romanised
tetanised1096512tetanised
totalised1048072totalised
womanised1545752womanised
banished14189063b__anished
bobtailed1443193bobta_iled
botanic1159583botani__c
botanica1295723botani_ca
botanical1366073botanical
botanicas1365253botanicas
botanising1345953botanising
botanizers2144283botanizers
braised104014803b_ra_ised
brutalised1363723brutalised
cognised1256313co_gnised
colonised12248723colonised
cutinised1245913cutinised
ebonised1136053ebo__nised
focalised15156953focalised
humanised1545953humanised
ionised82911493io__nised
kyanised16214163_kyanised
localised12167863localised
metalised12310463metalised
moralised1239663moralised
motorised1247263motorised
notarized1947153notarized
obtained1136533obta_ined
organised1146353organised
ozonised1853893_ozonised
paganised1346623paganised
polarised1269233polarised
romanise10312133romanise_
romanises11311573romanises
romanized2149213romanized
solarised1068043solarised
tetanise8610203tetanise_
tetanises979873tetanises
tetanized1988443tetanized
totalise8312503totalise_
totalises9311783totalises
totalized1949453totalized
urbanised1295123urbanised
vitalised1347203vitalised
vocalised15157393vocalised
womanise1348733womanise_
womanises1448063womanises
womanized2447043womanized

Search took 9 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.466383457.1
2DLD Change Limit148641588.00318573.2
3Display Results58580.060966.7
 (SQL Overall)178691588.52920951.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.