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

78 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
apostates114916(None) 
apostate1049851apostate_
apostacies1445602apostacies
apostasies1245582apostasies
apostatise1255252apostatise
apostatises1364572apostatises
apostatizes2264122apostatizes
apostles1037752apost_les
apostolates1354192apostolates
postages112815322_postages
postdates1248862_postdates
prostates11314422prostates
upstates10189642up_states
acetates102013063a_cetates
aerostats946713aerostat_s
agitates9310883a_gitates
amosites10311233amos_ites
amputates1345263amputates
annotates977293annotates
apatites10311293ap_atites
apholates1449683apholates
apocopates1644953apocopates
apophases1647973apophases
apoptoses1346443apoptoses
apostacy1544283aposta_cy
apostasy1344073aposta_sy
apostatised1473063apostatised
apostatize2164573apostatize
apostatized2383513apostatized
apostilles1244043apostilles
apostils1046773apost_ils
apostle937853apost_le_
apostolate1244513apostolate_
appestats1344503appestat_s
appetites1347513appetites
aristate8312133aristate_
aspartates1244673aspartates
costate94019273_costate_
epistases1146323epistases
epistaxes1844453epistaxes
estates74520183__estates
gestates93213733_gestates
hostages122311693_hostages
hypostases1846103hypostases
instates81615833_instates
misstates11710633misstates
notates72817483_no_tates
outstates91710753outstates
pectates122213953_pectates
portages112613223_portages
postage103214853_postage_
postals93716373_posta_ls
postdate1139653_postdate_
postdated1346883_postdated
postfaces1656273_postfaces
posthastes1546273_posthastes
posties93128813_post_ies
posttest10410233_post_test
postulates1268963_postulates
postures10313783_postures
potages102416423_po_tages
potatoes1039943_po_tatoes
pottages112910453_pottages
prostate10314533prostate_
prostrates12411993prostrates
restates83423433_restates
rotates72819773_ro_tates
spectates13228813spectates
spoliates1138543spoliates
states64337083___states
substates111410333substates
testates83615453_testates
unstates81314993_unstates
upstages11147373up_stages
upstares10178583up_stares
upstate91610493up_state_
upstater10156663up_stater
upstaters11174803up_staters

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.500357382.0
2DLD Change Limit148641786.83021763.0
3Display Results78780.0302600.0
 (SQL Overall)178691787.36024278.7
 
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.