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

85 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
motorings124597(None) 
moorings11257711mo_orings
motoring11410951motoring_
colorings1247682colorings
mooring102514442mo_oring_
motherings16255642motherings
motorises11311672motorises
motorists1149912motorists
motorizes20410782motorizes
bookings15358733bo_okings
borings103614243__borings
bottlings12215293bottlings
coloring11414843coloring_
cookings15358603co_okings
coverings15217893coverings
doctoring1346183doctoring_
floorings13245093floorings
footings12248833fo_otings
honoring12310473honoring_
jottings16275193jot_tings
kotowing1634013kotowing_
majoring1836363majoring_
matings104516213mat__ings
mattings11369673mat_tings
maturing1139953maturing_
mentoring1239543mentoring_
metering112915633metering_
metring103215293met_ring_
minoring11311473minoring_
mitering113015403mitering_
mitring103514143mit_ring_
modelings1335563modelings
moldings12267203mo_ldings
monitoring1346233monitoring_
monokines1547903monokines
monotints1147503monotints
mooing93718373mo_o_ing_
mooning103415553mo_oning_
mooting103019363mo_oting_
mornings11297923mo_rnings
morphings1744683morphings
mortaring1237943mortaring_
moshings14367333mo_shings
mothering152110183mothering_
motioning1247543motioning_
motiving1437163motiving_
motorbikes1852873motorbikes
motorbus1244443motor_bus
motorcars1394473motorcars
motordoms1444093motordoms
motoric11312223motori__c
motorise10311523motori_se
motorised1247263motorised
motorising1347513motorising_
motorist10314413motori_st
motorize19410433motori_ze
motorized2148663motorized
motorizing2248793motorizing_
motorless1145723motorless
motors84616603motor___s
motorways1742873motorways
mottling11197753mottling_
mouldings13273953mouldings
mountings12266163mountings
mournings1243533mournings
mousings11277703mo_usings
mowings13328483m__owings
noonings9246653no_onings
nothings12266683not_hings
notorious946213notorious
notornis845693notor_nis
outrings92811053_outrings
roarings9248293ro_arings
roofings12256023ro_ofings
shorings12269483_shorings
skiorings14243793skiorings
soarings93210393so_arings
sorings83817253__sorings
storing83921123_storing_
strings84617133_st_rings
toolings9248473to_olings
tourings9277373to_urings
tutoring938433tutoring_
vaporings1544093vaporings
waterings13229253waterings

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 Limit148641856.93621430.4
3Display Results85850.0461847.8
 (SQL Overall)178691857.40224140.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.