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

55 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
feijoa164222(None) 
feijoas1742321feijoas
frijol1634122frijol
bijou1458793_bijou
ceiba938703cei_ba
eidola737683_eidola
eidos65817753_eidos
eikon939463_eikon
enjoy1545963_enjoy
epizoa1745013epizoa
fajita1635923fajita
fecula113310053fecula
fedora1038593fedora
feign94210713fei_gn
feigns10407753feigns
feint84732253fei_nt
feints94813873feints
feirie939553feirie
feist86230073fei_st
feists94915313feists
feisty12449293feisty
fella84918653fe_lla
felloe93513923felloe
fellow123712743fellow
felon84619293fe_lon
femora1149583femora
feod815523003fe__od
feria85922713fe_ria
ferula93011173ferula
fervor1235643fervor
feta76528903fe__ta
fetor81214533fe_tor
fico95824593f_ico_
fido87726393f_ido_
fidos95819053f_idos
fiesta938123fiesta
fila74729133f_i_la
filo76034283f_ilo_
filos86125383f_ilos
finca104714503f_inca
fino76034693f_ino_
finos86226953f_inos
foison948933foison
frijole1734583frijole
frivol1235113frivol
geisha1035203geisha
genoa64315823ge_noa
hejira1644803hejira
hijra1535643_hijra
jerboa1535633jerboa
keitloa1141933keitloa
quinoa15377653quinoa
rioja1236303_rioja
seisor63712333seisor
seizor15428523seizor

Search took 7 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 Filter1786911127160.1401276364.3
2DLD Change Limit112716555.86019234.8
3Display Results55550.0134230.8
 (SQL Overall)178691556.01329717.4
 
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.