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

63 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
oratrices114583(None) 
brattices1345552brattices
matrices12312082_matrices
oratories9410642oratori_es
orrices9129362or__rices
avarices1337183ava_rices
aviatrices1543163aviatrices
brattice1245693brattice_
bratticed1443283bratticed
caprices1439893_caprices
carices114220953_ca_rices
cicatrices1343493cicatrices
cockatrices1852333cockatrices
cortices12615013cor_t_ices
diatribes1245533diatribes
editrices1245323editrices
fortalices1545513fortalices
fratricides1752583fratricides
gentrices1258913gentrices
heretrices1546303heretrices
heritrices1555303heritrices
latices9313763_lat_ices
latrines8515003_latrines
lattices1038383_lattices
matrixes1738063_matrixes
mortices12711563mor_t_ices
orates64328613orat___es
orations81515803orat_ions
oratorical1245163oratorical
oratorios944923oratori_os
oratress834553oratr_ess
oratresses1045493oratresses
oratrix1444533oratri__x
orifices1346483or_ifices
orreries8310123orreri_es
orrice81410163or__rice_
orrises71312233or__rises
ostriches1446633o_striches
outprices1337623outprices
outraces102217863o_utraces
outrides92414993o_utrides
outtricks1544323outtricks
ovaries10312653ova_ri_es
phratries1447583phratri_es
practices1557993practices
prairies10411453prairi_es
preprices1569263preprices
radices102314263_ra_dices
ratines75328583_rat_ines
ratites74920683_rat_ites
ratlines83815293_ratlines
rectrices1338873rectrices
reprices122913353_reprices
retraces101417273_retraces
retries74129073_retri_es
rotaries8315693rotari_es
statices102712343stat_ices
tectrices1346253tectrices
tortrixes1644153tor_trixes
trices84826333___trices
varices123313573_va_rices
veratrines1347263veratrines
vortices1369123vor_t_ices

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 Limit148641636.96621338.1
3Display Results63630.0331909.1
 (SQL Overall)178691637.42224075.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.