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

60 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
ostriches144663(None) 
ostrich1238662ostrich__
postiches1648222post_iches
astricted1247443astricted
astricts1049463astric_ts
astringes1038333astringes
enriches1337263_enriches
fetiches1636953fet_iches
mastiches1647333mast_iches
matrices12312083matric_es
oraches124216473o__raches
oratrices1145833oratric_es
orrices9129363o_rric_es
ossicles1054183os_sicles
ostioles839273ost_ioles
ostracise1146293ostracise
ostracises1245373ostracises
ostracizes2144723ostracizes
ostracodes1343073ostracodes
ostracods1253843ostracods
outbitches1742653outbitches
outfishes15118023outfishes
outpitches1743063outpitches
outprices1337623outpric_es
outraces102217863outrac_es
outreaches1545353outreaches
outrides92414993outri_des
outrushes1246653outrushes
outwishes15126563outwishes
pastiches1637453past_iches
postiche1547793post_iche_
potiches1539203pot_iches
riches115022083___riches
seiches12513813_s_eiches
seviches1635803_seviches
smirches1535993_smirches
soroches1338803_soroches
staithes1138953_staithes
stanches132312793_stanches
starches131912913_starches
stenches132110293_stenches
stichs114511653_st_ich_s
stitches131410593_stitches
stretches1438293_stretches
striates83417083_striates
stricken1436893_stricken
strickles1567813_strickles
stricks134310693_stric_ks
stricter1039423_stricter
strictest1147293_strictest
strides84520393_stri_des
strifes104716583_stri_fes
strikes114719093_stri_kes
stripes95320573_stri_pes
strives104119373_stri_ves
strophes13310603_strophes
tovariches1841943tovariches
trices84826333__tric_es
troches123715343__troches
utricles1037223_utricles

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.483369960.7
2DLD Change Limit148641607.80019056.5
3Display Results60600.0134615.4
 (SQL Overall)178691608.29621539.4
 
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.