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

71 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
ephorate135950(None) 
ephorates1459151ephorates
phorate12413361_phorate
apholate13410472apholate
ephoral1248402ephora_l
perorate10417912perorate
phonate12411812_phonate
phorates13413042_phorates
prorate9418732_prorate
amphorae1546263amphora_e
apholates1449683apholates
aphorise1339983aphorise
aphorize2249043aphorize
biforate1346903biforate
borate85026153__borate
camphorate19124963camphorate
chlorate133112693chlorate
cholate122114933_cholate
chorale124313353_chorale
chordate1448033_chordate
cohobate1547013cohobate
decorate11315193decorate
depurate1139983dep_urate
echinate1359403echinate
elaborate1146873elaborate
emeerate10410093emeerate
emigrate1149603emigrate
emirate91015833e_mirate
ephor10310013ephor___
ephori1139603ephor__i
ephors11311403ephor__s
epilate9314283ep_ilate
ethylate1446213ethylate
etiolate849523etiolate
evaporate1445493evaporate
excoriate1846883excoriate
execrate1739643execrate
exhort16410803exhor_t_
exhorted1935013exhor_ted
exhorter1845353exhor_ter
exhorts1746313exhor_ts
horste94817413__horste
meliorate1179483meliorate
nephrite1346713neph_rite
operate9615733op_erate
orate55133303___orate
perborate13510133perborate
perforate1459453perforate
perorated12412443perorated
perorates11417013perorates
phenate12412193_phenate
phonated1447893_phonated
phonates13410643_phonates
phrase11109903_ph_rase
picrate112014143_picrate
pirate82322883_p_irate
prate75135983_p__rate
priorate10411733priorate
probate11414483_probate
prolate9419793_prolate
pronate9418873_pronate
prorated11513713_prorated
prorates10418063_prorates
rectorate11411353rectorate
rephrase1346733reph_rase
reprobate1347683reprobate
separate10310783sep_arate
sororate8411173sororate
tephrite1346593teph_rite
thorite10313443_thorite
uprate83916543up__rate

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 Filter1786911461620.1731032896.0
2DLD Change Limit146162718.84316528.6
3Display Results71710.0164437.5
 (SQL Overall)178691719.03219784.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.