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

48 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
optimises134608(None) 
optimise1255581optimise_
optimised1444311optimised
optimisms1555221optimisms
optimists1345291optimists
optimizes2245421optimizes
opticists1346422opticists
optimes1148472optim__es
optimism1445212optimis_m
optimist1256872optimis_t
optimize2145502optimize_
optimized2344962optimized
optimizer2244122optimizer
optimizers2343022optimizers
otitises839162o_titises
atomises103514403_atomises
cutinises1148513cutinises
epitomises1445313epitomises
intimists1147493intimists
itemises1087693_itemises
maximises2044873maximises
minimises1347163minimises
opiumisms1542633opiumisms
optatives1445203optatives
opticians1345543opticians
opticist1248923opticis_t
optime1079353optim__e_
optimising1544493optimising
optimistic1654303optimistic
optimums1442563optim_ums
optionees1144343optionees
ostomies10310583ostomi_es
ostosises946233ostosises
otitides937293o_titides
outraises9311023outraises
outsmiles1146443outsmiles
oxidises1644833o_xidises
phimoses1537203_phimoses
premises123018273_premises
primines123013703_primines
primuses1237083_primuses
promises122916763_promises
satirises9410193satirises
stimies9316563_stimi_es
tamises92715973__tamises
uptimes1177553uptim__es
utilises848973_utilises
victimises1774093victimises

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.436409841.7
2DLD Change Limit148641487.22020587.4
3Display Results48480.0163000.0
 (SQL Overall)178691487.67223291.3
 
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.