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

45 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
geranials104591(None) 
geranial949281geranial_
geraniols1044741geraniols
geraniol945142geraniol_
geraniums1245252geraniums
aerials74017553aer__ials
berascals1343503berascals
ceramals1246513cera_mals
cranial92114683_cranial_
denials84114133de__nials
derails84216393dera_i_ls
galangals1142903galangals
gavials1136603g__avials
gazanias1845733gazania_s
genial74917613ge__nial_
genitals937243ge__nitals
geranium1147053gerani_um
gerardias1144403gerardia_s
gerbils1037303ger_bi_ls
germaniums1543873germaniums
germanizes2248153germanizes
germinal1147263germinal_
gerundial1142803gerundial_
gharials1245123g_harials
graals74112913g_ra__als
graduals1046203g_raduals
grails77518783g_ra_i_ls
grandads1136553g_randads
grandams1237123g_randams
granitas92610223g_ranitas
granites92116363g_ranites
granolas938053g_ranolas
gremials1136133g_remials
hernial10310433her_nial_
hernias10310773her_nia_s
menials94015693me__nials
perennials1244893perennials
radials83614643__radials
serails73318363sera_i_ls
serials73919753ser__ials
terminals1147463terminals
tertials8510073ter_tials
uranias72113813_urania_s
verandahs1642293verandahs
verandas1246233veranda_s

Search took 9 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.453394461.4
2DLD Change Limit148641458.17318186.8
3Display Results45450.0133461.5
 (SQL Overall)178691458.63920684.2
 
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.