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

59 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
expiators184680(None) 
expiator1747041expiator_
expiatory2145181expiatory
epilators1149432e_pilators
excitors1746092exci_tors
expiates17810212expiat_es
expiations1959662expiations
expiratory2244732expiratory
explicators2244712explicators
aspirators1247003aspirators
aviators11169913_aviators
depictors1465943depictors
depilators1347333depilators
deviators1358543deviators
editors839423e_di_tors
educators1246993educators
elevators1246303elevators
emanators1147033emanators
emulators1148183emulators
epilator1049243e_pilator_
equators1737473e_quators
estimators1247023estimators
estivators1345923estivators
evictors13276853e_victors
evocators1446713evocators
exactors1737023ex_actors
excavators2243543excavators
excitatory2254343excitatory
exciters1736323exci_ters
excitons1746043exci_tons
excitor1645993exci_tor_
execrators1946023execrators
executors1844653executors
exhibitors2252793exhibitors
expandors19142833expandors
expats1537683exp_at__s
expecters2045473expecters
expeditors2043643expeditors
expiate16910593expiat__e
expiated18168523expiat_ed
expiating1938543expiating
expiation18710423expiation
expirations2069583expirations
expirers1735123expi_rers
expletory2142973expletory
explicator2145153explicator_
explicatory2553843explicatory
exporters1846253exporters
expositors1943963expositors
expurgators2152563expurgators
extirpators2053163extirpators
extractors1946423extractors
mediators1248923mediators
obviators1444853obviators
radiators1049333radiators
respirators1375443respirators
supinators1245643supinators
viators102712023__viators
vitiators1246923vitiators

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.406440125.6
2DLD Change Limit148641597.15620771.5
3Display Results59590.0134538.5
 (SQL Overall)178691597.57523589.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.