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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

43 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
schizopods2714249(None) 
schizopod26142531schizopod_
chilopods1774642_chilopods
rhizopods2452592_rhizopods
schizoids2443382schizo_ids
chenopods1743953_chenopods
chilopod1694653_chilopod_
chiropody2053093_chiropody
rhizopod2352343_rhizopod_
scaphopods2052213scaphopods
schizogony2851543schizogony
schizoid2344353schizo_id_
schizonts2342463schizo_nts
schizos21115433schiz__o_s
brachiopods2192054brachi_opods
chaetopods1852114_chaetopods
chenopod1643944_chenopod_
chinooks1774784_chino_oks
chiropodies1954034_chiropodies
chiropodist1953564_chiropodist
echinoids1544224echino_ids
isopods1045574___isopods
myriopods1751824myri_opods
octopods1344344oc__topods
rhizoids2143464_rhizo_ids
rhizopus2241834_rhizop_us
satinpods1242344sati_npods
sauropods1293674s_auropods
scaphopod1952324scaphopod_
schistous1443864schi_stous
schizo20115994schiz__o__
schizocarp2851534schizocarp
schizocarps2961274schizocarps
schizogonic2861674schizogonic
schizogonies2761764schizogonies
schizogonous2761134schizogonous
schizont2244714schiz__ont
schmoos14347514sch_mo_o_s
schnooks1754244sch_no_oks
schools1249114sch__o_ols
schrods1337434sch___rods
shippons15255664s_hi_ppons
theropods1544964_theropods

Search took 10 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 Filter1786911614500.436409841.7
2DLD Change Limit161450439.29617367.7
3Display Results43430.0162687.5
 (SQL Overall)178691439.74818331.0
 
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.