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

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
allegorists128340(None) 
allegorises1283591allegorises
allegorist1184761allegorist_
allegories1185392allegori_es
allegorise1183492allegoris_e
allegorised1382512allegorised
allegorizes2183622allegorizes
algorisms1246173a_l_gorisms
allegoric1244113allegori__c
allegorical1452283allegorical
allegorising1452113allegorising
allegorize2083473allegori_ze
allegorized2293093allegorized
allegorizer2182673allegorizer
allegorizers2281853allegorizers
allergists1144203alle_rgists
ableists1036544able___ists
agonists9289834a___gonists
algebraists1491354algebraists
algologists1346144algologists
algorism1147354a_l_goris_m
alienists946914alie__nists
allegations1246044allegations
allegers9378234alleger___s
allegiants1143874alleg_iants
allegorizing2352574allegorizing
allegory1244294allegor___y
allegretto1151844alleg_retto
allegrettos1251164alleg_rettos
allegros945084alleg_r__os
allelisms1156004alle__lisms
allergist1046844alle_rgist_
allethrins1353264allethri_ns
allografts1453094allog_rafts
allsorts844914all_sor__ts
altoists848754a_l_to_ists
amorists10411324a___morists
antagonists1294804antagonists
aorists74215824a____orists
aphorists1448254a__phorists
arborists1147444a__rborists
auteurists1045084aute_urists
balloonists1353024ball_oonists
belletrists1352824belle_trists
categorises1454334categorises
colorists112313594col__orists
egoists887074___ego_ists
egotists937064___egotists
elegists9128114_eleg__ists
flavorists1643524_flavorists
florists1138814_fl__orists
folklorists18111774folklorists
legalists1047944__legalists
legists899594__leg__ists
meliorists1245984mel_iorists
panegyrists1751804panegyrists
rigorists1045674__rigorists
tenorists948194__tenorists
theorists1246594_the_orists

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 Filter1786911488190.1561145455.1
2DLD Change Limit148819599.32615957.4
3Display Results59590.0331787.9
 (SQL Overall)178691599.51518779.9
 
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.