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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

104 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
motorises1131167(None) 
motorise10311521motorise_
motorised1247261motorised
motorists1149911motorists
motorizes20410781motorizes
memorises131211582memorises
moonrises1146722moonrises
morrises10711072mo_rrises
motorbikes1852872motorbikes
motorbuses1443742motorbuses
motorings1245972motorings
motorist10314412motoris_t
motorize19410432motorize_
motorized2148662motorized
motorless1145722motorless
aphorises14310003aphorises
atomises103514403_atomises
authorises1347583authorises
botanises1139163botanises
clitorises1246103clitorises
colonises112814013colonises
colorisms132810793colorisms
colorists112313593colorists
colorizes203014523colorizes
comprises15510943comprises
coteries10422703coteri_es
lorises73918593__lorises
lotoses73713643loto__ses
matrices12312083mat_rices
matrixes1738063mat_rixes
melodises1247603melodises
memories121214353memori_es
memorise121411433memorise_
memorised14118223memorised
memorizes221310823memorizes
merises93421423m__erises
metalises11315073metalises
meteorites1247613meteorites
methodises1645463methodises
metrists1039853met_rists
mitises9315543mit__ises
mitoses9312183mito__ses
mobilises1347513mobilises
modernises1344733modernises
moisturises1353233moisturises
monetises11311043monetises
monitories1248893monitori_es
monodies11312503monodi_es
monodists1247703monodists
monokines1547903monokines
monoxides1946133monoxides
moonrise1046783moonrise_
moorages1139053mo_orages
moorier93113073mo_ori_er
mooriest102812723mo_oriest
moorings11257713mo_orings
moorish123311783mo_oris_h
moperies12313873moperi_es
moralises11314003moralises
moronisms1348173moronisms
mortises10713613mo_rtises
motiles93317433mot__iles
motives123611893mot__ives
motocross1344223motocros_s
motocrosses1552753motocrosses
motorbike1743303motorbike_
motorbiked1952163motorbiked
motorbus1244443motor_bus
motorbusses1552133motorbusses
motorcades1543773motorcades
motorcars1394473motorcars
motordoms1444093motordoms
motored1039933motor__ed
motoric11312233motori__c
motoring11410953motori_ng
motorising1347513motorising
motormen1245703motor_men
motors84616603motor___s
motorways1742873motorways
myosotises1543653myosotises
noncrises11129313noncrises
notaries8314933notari_es
notarizes1848713notarizes
notorious946213notorious
odorizes1837213_odorizes
orrises71312233_o_rrises
ostosises946233ostosises
otitises839163_otitises
ozonises1776373_ozonises
polarises11514073polarises
rotaries8315693rotari_es
satirises9410193satirises
solarises9512703solarises
sorosises947303sorosises
stories7324273_stori_es
theorises1247813theorises
tories65435883__tori_es
torses64727953__tor_ses
tortoises947183torto_ises
totalises9311783totalises
valorises122210183valorises
vaporises14209453vaporises
votaries11312013votari_es
votarists1298603votarists

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.420425454.8
2DLD Change Limit1486411047.28020417.7
3Display Results1041040.0502080.0
 (SQL Overall)1786911047.75023056.9
 
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.